Hi,
I am trying to work out a formula that will calculate a shift penatly between a start and finish time.
The penalty is and early shift penalty so if an employee works between midnight and 7am then they should get $2.20 for each hour worked between these times.
I have attached the workbook I am working on.
Start time is in cell M1637, Finish time is in N1637, total hours worked is P1637.
I am trying to write the formula in Cell AK1637, and the reference fot the $2.20 is in cell Ak1635.
Miss seems to be if the employee starts the shift before midnight but finishes after, the formula I have already does not calculate correctly.
Please help!!
Bookmarks