Calculate reg hours, over time hours and double over time hours

[excelnovice2000]

Hello,
I am trying to calculate regular hours, over time hours and double overtime hours. Here are the rules

A day with 8 or below 8 hours worked is regular hours

A day with 11 hours worked 8 hours are regular hours and 3 hours are over time

A day with 13 hours worked 8 hours are regular hours, and 4 hours are over time and 1 hour is double over time

I have attached a sample workbook with a solution

Really appreciate all your help

 

[ETAF]

when does double time kick - i have at 12 hours
so a day with 12 hours - is 8 regular and 4 overtime and 0 double time


i have used 3 IF
in regular hours C2
=IF(B2<=8,B2,8)

in Over Time Hrs D2
=IF(B2>8,IF(B2>=12,4,B2-8),0)

in Double Over Time Hrs E2
=IF(B2>12,B2-12,0)

 

[excelnovice2000]

when does double time kick - i have at 12 hours
so a day with 12 hours - is 8 regular and 4 overtime and 0 double time


i have used 3 IF
in regular hours C2
=IF(B2<=8,B2,8)

in Over Time Hrs D2
=IF(B2>8,IF(B2>=12,4,B2-8),0)

in Double Over Time Hrs E2
=IF(B2>12,B2-12,0)

Hi,
Yes, double over time kicks in after 12 hours.
Thanks for your solution. Really appreciate you solving the problem

 

[excelnovice2000]

Hi,
Yes, double over time kicks in after 12 hours.
Thanks for your solution. Really appreciate you solving the problem

Sorry, I mistyped in my previous response. Yes double over time kicks in after 12 hours

 

[ETAF]

you are welcome