adding a value in a cell based off another cell

[northernwarrior]

What I am trying to achieve is adding either 30 mins or 1hr worth of paid breaks if some criteria is met

criteria is :

anything over 5hrs worked = 30mins, however if the time is over 10hrs its =1hr

in my worksheet that is attached

column d is where the total hours for the day would be. d4 has 7.45. this would equal 30mins pay in column h4(0.50 ), however if d4 was changed to 10.45, then h4 would have 1.00.

is this possible ?

[Fluff13]

How about

Please Login or Register  to view this content.

[Pete_UK]

You can use this formula in H4:

=IF(D4>=10,1,IF(D4>=5,0.5,0))

Copy down as required.

Hope this helps.

Pete

[northernwarrior]

sweet !!!!

Thanks !!!

[Fluff13]

Glad to help & thanks for the feedback.