Calculate regular hour, over time hours and double over time hours

[productowner]

Hi,
I am trying to calculate regular hours, over time hours and double over time hours based on totals hours for the day.

1. Regular hours are 8 or less than 8 hours
2. Over time hours are greater than 8 but less than 12 hours in a day
3. Double over time hours are any hours greater than 12 hours in a day

I have attached sample desired result in the spreadsheet.


Thanks for your help.

 

[mohamed ilyas]

Hi,

please find the attached as requested.

regards
ilyas

 

[productowner]

Hey Ilyas,
Really appreciate your help in solving the problem. Thanks again.

 

[p45cal]

F4:
=MIN(E4,8/24)

G4:
=MIN(E4-F4,4/24)

H4:
=E4-F4-G4

all copied down.