Question Date / Time

[Leonardo_BONORI]

I have a table with two columns “Time” and “Shifts”.The Shifts are divided in three different schedules (“Day” from 8:00 am to 4.30 pm , “Afternoon” from 4.30 pm to 0.30 am and “Night” from 0.30 am to 8.30 am).
The entry of “TIME”, is with the expression TIMENOW.
I need according to this schedule in the column “Shift” to show automatically if it is Day, Afternoon or Night.

Best Regards,

[Marc_Dillon]

help.appsheet.com

IFS()

First-match conditional evaluation

[Leonardo_BONORI]

Thank You Marc!!
this post was very helpful

Working with Time to Categorize as a "Shift" Questions

This suggests the column type is DateTime. If you change the column type to Time, you won’t have to worry about the unwanted (and potentially problematic) date component. Here’s your express reformatted the way I prefer (just aesthetics, not functional): IFS( TIME([Start Time]) < TIME(12:00:00), “Morning (8AM-Noon)”, AND( TIME([Start Time]) > TIME(11:59:59), TIME([Start Time]) < TIME(16:00:00) ), “Midday (Noon-4PM)”, AND( TIME([Start Time]) > TIME(15:59:59), TI…