timevalue expresion

[MACMAX]

google sheets has an expression called timevalue that calculates the duration between a time interval regardless of the time, for example it can calculate the duration from 6:00 pm to 3 am but I can't find that expression in appsheet, can I replace it with other? thanks for help me

[WillowMobileSys]

AppSheet uses the "-" and "+" operators between two Date Time or Time columns to compute a value of type Duration.  For example if I have a Start Time and an End Time, I simply need to do this:

[End Time] - [Start Time]

The result is the duration between the two.

You can find out more in this article:

https://support.google.com/appsheet/answer/10107326