Hello i am trying to create a formula to calculate overtime in excel, the problem i am having is i need to calculate: total time, Regular Time and Overtime, but the overtime is only after 40 Regular time hours have been reached. i have it to where it will calculate overtime but it does it for any hours worked after 8. i just need after 40. i have a copy of the time sheet attached. thank you!!! need this ASAP!!! ALSO i need to keep the formula in total time to calculate from one day into the next, we work 24/7 365 so we can go from one day into the next. i have attached a copy of our time sheet.

Attached Files

Copy of Express Time Sheet new 1.0 Master.xlsx (16.8 KB, 17 views)