I'm in charge of calculating overtime where I work and at this point it is all done manually.

The more I learn about excel, the more I realize how powerful it is, so I'm wondering if someone can let me know if this is possible or not:

Our overtime is calculated based on:

- The empoyee will receive 1.5 times the hourly rate for time worked over 8 hours per day or 40 hours per week (whichever is greater) and 2.0 times for time worked over 12 hours per day.

So for example:

Billy worked:

Monday - 8 hours

Tuesday - 8.5 hours

Wednesday - 9 hours

Thursday - 7 hours

Friday - 6 hours

Total hours: 39.5

Total hours over 8 hours per day or 12 hours per day: 1.5

Total hours were less than 40, so 1.5 hour is greater, so that's the number I would use.

Sally Worked:

Monday - 9 hours

Tuesday - 14 hours

Wednesday - 8 hours

Thursday - 8 hours

Friday - 8 hours

Total hours: 47

Total hours over 8 hours per day (7) over 12 hours per day (2) = 9 overtime hours

9 hours is greater than (47-40) so I would use 9 hours

I know this is complicated and time consuming. I've donated to the forum before and would be happy to again if anyone can help.

Thanks!