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 |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |