Formula for calculating regular and overtime hours based on a full week with an 8 hour day.

Our take

Calculating regular and overtime hours can seem daunting, especially with multiple employees and varying work schedules. To accurately assess hours worked, you can create a formula that designates up to 8 hours per day as regular time, with any hours beyond that classified as overtime. This approach also applies to all hours worked on weekends.

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.

https://preview.redd.it/i0ahs8oaf6yg1.png?width=429&format=png&auto=webp&s=e0e29134a1630561de2bc997571fab197ceabf43

Please help. Thank you!

submitted by /u/Ok-Fail-4340
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#AI formula generation techniques#formula generator#Excel compatibility#real-time data collaboration#real-time collaboration#Excel alternatives#rows.com#cloud-based spreadsheet applications#financial modeling with spreadsheets#overtime#regular hours#hours worked#excel#formula#employees#calculation#week