Dates filled using formula.
F shift on weekdays from 10:20 AM – 9:30 PM, weekends 10:30 AM start, 2 hours break.
M shift on weekdays from 10:20 AM – 6:30 PM, weekends 10:30 AM start, 1 hour break.
A shift from 1:20 PM – 9:30 PM daily, 1 hour break.
Weekends are Saturdays and Sundays.
How to calculate into a single cell?
Bookmarks