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
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
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |