Mon Tues Wed Thurs Fri Sat
Sun
IN 9:00AM 9:00AM 9:00AM 0 9:00AM 9:00AM 9:00AM
Pantry
OUT 3:00AM 3:00AM 3:00AM 0 3:00 AM 3:00AM 3:00AM
Sautee
Total Hours 23.00 23.00 18.00 18.00 18.00
18.00 126.00
Reg. Hours OFF 40.00 O.T. Hours
6.00 24.00 24.00 42.00 60.00 78.00
78.00

Regular and overtime rates are in this template. Whats the formula used to
automatically recognize overtime as you prepare the schedule? I used 23 & 18
hour shifts in this test to show overtime by tuesday.