Hello Appsheet friends,
I am trying to set a [Overtime] field where [Check Out Time] is later than 6.50pm are considered as [Overtime]. For instance, [7pm] - [6.50pm] = 50 minutes OT (but considered as 1 Hr), any checkout time not later than 6.50pm are not considered as OT.
But I kept getting weird values.
Instead of subtracting TIME(“018:50:00”) simply try to subtract “18:50:00”
Please be aware that any time duration related computations done on time parameters need to be on the same calendar day. If calendar day is changing, you may need to bring in date component in the expressions.
Once again, thanks for the help Suvrutt 
You are welcome.
Just to add, in AppSheet a time value is denoted as “09:30:45” but an equivalent duration is denoted by “009:30:45”. Please note one additional “0” in the duration value.
Thanks for the guide Suvrutt, say for example, if I would like to set a more stringent condition for Duration, and make sure Date(Today), Time ( “09:30:00”)
My current expression is as below, do I need to explicitly set Date(today()) or it will be recognized as Today by default?
AND(ISNOTBLANK([Check Out Date Time]),TIME([Check Out Date Time]) > “18:50:00”)
Are you facing any issue with the existing expression you have shared? May we know why you would like a stringent condition you mentioned?
