How to calculate standard hours, and overtime premium seperately

[suma]

Hi,

I need to find a formula that can calculate and seperate overtime premium from total hours worked.

If someone works 49 hours, and is contracted for 39 hours, I need the hours to be calculated as below

Total hours 49 49
Overtime premium at 1/3 of time 4 (restricted to 4 hours) 4
Overtime premium at 1/2 of time 4 (restricted to 4 hours) 4
Overtime premium at double time 2 (no restriction 2

I have attached a sample spreadsheet.

Many thanks

Sean