Calculate Overtime and Double time Hours

I am attempting to create a time sheet for employees to provide total hours entered for each day of the week and have the hours split between three pay rates.

M-F first 8 hours are regular pay; next 2 would be at time and half; after 10 hours - Double Time.
Saturday is at time an half
Sunday is at Double Time

I am having an issue with the time and half calculation, if the employee works a 12 hour day, double time is calculated correctly, but the two hours at time and half are added back to the regular hours.

What formula can I use to replace mine so 2 hours of time and half gets picked up for a 12+ hour day?

Paste the following equation in to cell I3:

Formula:

Please Login or Register  to view this content.

Thanks for your response, it seemed to work, but once I change the hours worked on any day, it reverts back to the missing 2 hours

It's circuitious but

Please Login or Register  to view this content.

Take all the hours greater than 8, then remove the double time (less the Sunday hours).

This was the biggest part of my day, that is what I was looking for.

Thank you