Duration between two Time values

[Jon_S]

Hi everyone,

I’ve noticed that the formula given to calculate the difference between two time values in the documentation doesn’t work great when trying to calculate the duration of someones sleep (for example).

Here’s the formula:
IF(([StopTime] > [StartTime]), ([StopTime] - [StartTime]), (([StopTime] + 24) - [StartTime]))

When the [Start Time] = “13:00:00” and [End Time] = “15:00:00” the DURATION result is correct. But when we have a [Start Time] = “22:00:00” and [End Time] = “07:00:00” the result is “-09:00:00”…

I understand that Appsheet doesn’t understand that there’s a new day that started between 23:00 and 07:00

Ideally i would need something like a DATETIME_DIFF() expression just like you would have in Airtable so you would be able easily calculate this.

Has any body else solved this? Any good approaches i could try?

Many thanks in advance