Hello,
I am trying to compute regular hours and over time from total hours column. Please see attached sample spreadsheet with desired output.
Thanks for all your help
excelnovice2000
Is Your used (Working) week from Monday to Sunday or how?
Based Your Regular hours for each employee should 40 hours for a week and anything over 40 hours are overtime hours. Sorry for the confusion.
and Your Desired Output ....
Why there are OT Hrs before 40 hours?
24-Oct ... 27-Oct is 32:30, 28-Oct + 8:30 >> 40:00 + 1:00 (OT)
Or
Do You use something like rolling week to solve OT?
... Mon to Sun 40hrs > Tue to Mon 40hrs > Wed to Tue 40hrs ...
excelnovice2000
So why You've written too:
Regular hours for each employee should 40 hours for a week and anything over 40 hours are overtime hours. Sorry for the confusion.
There were nothing about daily hours.
That could be so different than Your other ... version.
Can you explain why Saturdays' peculiar Regular/Overtime splits?:
View attachment 81655
You've also got a Sunday (30th) in there, what are the REG/OT hours for Sunday?