Good afternoon! I have two columns: Start and End. I need the “Free Time” column to fit the time between Start and End, to have a select list. Tell me, please, how to do it? The formula I’m using doesn’t work, it just outputs one numeric value.
Hi @oskotskayasvetlana
Could you give me a little explanation of what you mean telling “to have a select list” ?
The formula is quite simple if you want to get time between 2 dates
But i’d like to understand what use of this column you’d like to do ?
Thanks
Quentin
sorry, this is not exactly what I need.
for example, my start date is 15 December 10:00 and the end date is 15 December 12:00
i need i have a select list with values 10:00, 11:00, 12:00
Thanks!
OK, step by step then 
We can extract what you want
So now to finish, remove the bulletedList at the end (that was just to make it clearer in the first place)
Create a select list with these option, and now you can select any time you want !
Let me know if this is OK
Quentin
it’s ok! Thank you very much!
but if the time value is, for example, 11:30, then the formula does not work correctly ((
Do you want to have also half time as possible selection, or just round time, but after start time and before end time ?
For example if you have 11:30, you want the first proposal to be 11:30 or 12:00 ? (Not 11:00, I understand )
i want to be able to put any time like 11:00 or 11:15 or 11:30 for example)
Hmm, if you want to build a select list option, we need to define those option
for example if start/end is 09:30/11:00, we have different option 
:
- Working only with full hours > 10:00, 11:00
- Working with half hours : 09:30, 10:00, 10:30, 11:00
- Working with quarters hours : 09:30, 09:45, 10:00, 10:15, 10:30, 10:45, 11:00
But if you want to set it in a select list, we must define before what range you want to use.
Otherwise, this is just a “free & manual” field, and you can set a control to check if the value you select is within range or not, like this.
But using a select list require to define what we want inside this select list ;
Let me know !
thank you for answer)
I mean, the start can start at exactly 11 or 10 and so on, or at 12:30 or 11:30 and so on
OK, So if I understand well, you want to work on hourly basis, but according to the start time
If you’ve got start/end = 15:30/18:30, the available option will be 15:30/16:30/17:30/18:30, right ?
Thus, it suppose that the ending time has the same format as the starting time… ?
I would like the list to work not only with the time 11:00, but also 11:30, for example) ) , that is, with the value that I will set
According to minute of hour in Start Date, you can set this like this. I propose every hours from the starting time, and according to end time, I filter to be sure that the last proposal is well inside the range
Have a look : in second row, it starts from 1:15 PM, so it suggest 1:15 and 2:15, but NOT 3:15 PM because 3:15 PM is after ending time.
I assume this fits your needs now, doesnt it ?!
it’a great)) thank you very much
1 Like
We finally did it Enjoy this new features then !
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.