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,
Thank You Marc!!
this post was very helpful
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |