Standby Hours Formula not working correctly? Need your expertise please:)

[pcannon]

Hi folks,

I'm trying to set up a time sheet that will calculate Standby correctly. Standby for our Officers are calculated 1/2 hours pay at regular rate for each 4 hours on standby or any portion thereof. Using the 24 hour clock this is the formula I set up

=ROUND(IF((((H6-G6)+(J6-I6))*24)>24,24,((H6-G6)+(J6-I6))*24/4*0.5),0)

but its not working correctly...see the example I highlighted...this should be calculating in the SBY column as 1.5 not 1

what am I missing?

Thank-you for any advice you can provide
P

[shg]

In O8,

=CEILING((H8-G8+J8-I8) / "4:00", 1) * 0.5

[pcannon]

Perfect! Thank-you for your time Have a great day!

[shg]

You're welcome.