Question Date / Time

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,

3 Likes

Thank You Marc!!
this post was very helpful

2 Likes