Formula for calculating regular and overtime hours based on a full week with an 8 hour day.
My excel sheet has multiple employees, dates and the total number of hours worked for that day per employee.
I currently have a formula that calculates 40 for the week as regular time then the remainder is overtime but that's not how our overtime works.
I need to create a formula(s) to calculate hours per day up to 8 as regular time then the remainder is overtime including all day Saturday and Sunday
I know this should not be as difficult as my mind has made it but for the life of me, I can not figure it out, plus I'm old so using AI is out of my scope.
For example, Christian only had 26 hours for the week so my current formula does not figure any overtime when he should actually have 16 regular hours and 10 overtime hours. Also for example, Adan should have 24 regular hours and 39 overtime hours.
Please help. Thank you!
[link] [comments]
Want to read more?
Check out the full article on the original site