I have a working time sheet that we have been using for years and it functions very well. It is currently based on a 44 hour work week. I need to alter it so that it also takes into account the amount of hours worked in a day. It needs to calculate overtime after 8 hours in a day and when the cumulative time worked in the week exceeds 44 hours.
Joe Technician works 9 hours on Monday and then works 8 hours a day for the rest of the week. While he doesn't break the 44 hour threshold for the week he would still get paid 1 hour OT for the 9 hours he worked on the Monday. Conversely if he worked 10 hours a day for 5 days, by the 5th day he would get 4 hours of regular time and the remaining 6 would be paid as OT since he crossed the 44 hour threshold after 4 hours worked on the 5th day.
I've included examples in the worksheet that shows how the current formula works. I would like to keep the current functionality and add in the 8 hour calculation.
The formulas that I need to alter are located in cells E22:K22.
Thank you in advance.