OT and DT Calculations

Hello I am battling with formulas in my spreadsheet for hourly payroll.

In our plant, a regular day (or REG time on attached example) is 8 hours, then overtime (OT) kicks in for up to 12 hours then it is double time (DT) for any hours over 12. Also, any hours beyond 40 hrs per week is Overtime (OT) BUT per the union, anything over 12 hours of OT in a week (a week being Monday to Saturday for this purpose) must be calculated at DT (plus any work on Sunday is DT regardless of hours worked).

So I figured out how to calculate the OT if the reg shift is more than 8 hrs but can't seem to figure out how to do the following:

-OT - (column G) if more than 4 hours, any additional hours should go to DT (column H)
-if total hours per week (E14 or E24) is more than 40, any additional hours should be OT
-once total OT gets to 12 for the week, any additional hours should go to DT

is it possible to get excel to do all this just by me entering the start and end times or am I dreaming??

it's really close, I think - except I should never have more than 12 total hours of OT as anything over 12 hrs OT in a week have to paid out as DT (so if John Doe worked 66 hours in a week total, then 40 would be paid as REG, 12 would be paid out as OT then the other 14 would have to be DT. So my total reg can't ever equal more than 40, OT can't equal more that 12 and DT can be anything)

OH I see now LOL - thanks!!