Datetime

[cuadromoreno]

I'm trying to identify de night shift it goes between 8pm and 6am noting that if there's less than 3,5 hours of work during that period, the labor day will have 7,5 hours and when more than 3,5 hours during that period, the labor day will be set at 7 hour period.

I'm using datetime expressions but fail to construct the date to compare when Time in is before midnight or timeout is after midnight. Something like [Time_out] < DATETIME(TEXT([Time_out], "mm/dd/yyyy 24:00:00")) doesn't work. Any ideas?? internet is very poor when it comes to Appsheet

[Marc_Dillon]

I recommend recording [time_in] and [time_out] as datetimes. Then you don't have to worry about any complicated conditional expressions.