Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
recognizing overtime while preparing a schedule
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a help of preparing excel macro | Excel Discussion (Misc queries) | |||
Overtime Calculation for Overtime | Excel Worksheet Functions | |||
=SUMPRODUCT((Overtime!$J$6:$GY$6-DAY(Overtime!$J$6:$GY$6)+1=A25)*(Overtime!$J$7:$GY $2 | Excel Worksheet Functions | |||
excel formula to recognize overtime in a day as you prep schedule | Excel Programming | |||
Excel and preparing email | Excel Programming |