Time difference formula between two single-select fields

[PeterJNCK]

Hello,
I am trying to make the process of time tracking more user-friendly. Instead of using the duration field and writing manually each time record, I would like to use two single select fields as StartTime and EndTime pickers, each containing values 00:00, 00:15, 00:30, 15:30, 15:45, 16:00, etc.

But I am stuck with a formula that makes a magic difference between these two times.
Is it even possible with a formula, or does it need to be done with some sort of script?

Thank you 

[preshetin · Accepted solution]

Hi Peter - this can be done with a formula. It may look like this:

DATETIME_DIFF(

DATETIME_PARSE({End Date} ,'HH:mm'),

DATETIME_PARSE({Start Date},'HH:mm'),

'minutes')

Here is how it works in action:

[PeterJNCK]

@preshetin Thank you!! Now it looks so simple 🙂

[preshetin]

Happy it worked for you @PeterJNCK  - in case you have additional questions feel free to send me a DM