staff schedule

[imported_unknown]

I am trying to create a staff schedule. It will finally figure the hours between start and end time, and subtract .5 hour for lunch. Now I need to add another condition for those working less than 5 hours. These should not have the .5 subtracted. This is how I was doing it so far.
=IF((24*(IF(C8>D8,D8+1-C8,D8-C8))-0.5)>0,(24*(IF(C8>D8,C8+1-C8,D8-C8))-0.5),0)
Help?
Thanks.

 

[flexinau]

what is C8 and D8 exactly?

 

[flexinau]

This formula will not work for difference in start and end times of 24 hours or more as the formula does not know the days worked.
Formula should work since no staff will work 24 hours straight.
For work of greater than 5 hours, the formula will take .5 hours for break. 5 hours or less, no 0.5 hours for breaks are deducted.

=IF((24*(IF(C8>D8,D8+1-C8,D8-C8))-0.5)>5,(24*(IF(C8>D8,D8+1-C8,D8-C8))-0.5),24*(D8-C8))

 

[Yogi Anand]

On 2002-10-04 23:07, GLD wrote:
I am trying to create a staff schedule. It will finally figure the hours between start and end time, and subtract .5 hour for lunch. Now I need to add another condition for those working less than 5 hours. These should not have the .5 subtracted. This is how I was doing it so far.
=IF((24*(IF(C8>D8,D8+1-C8,D8-C8))-0.5)>0,(24*(IF(C8>D8,C8+1-C8,D8-C8))-0.5),0)
Help?
Thanks.

Hi GLD:

Welcome to the Board!

Try ...

=IF(((D8-C8)+(C8>D8))*24>5,((D8-C8)+(C8>D8))*24-0.5,((D8-C8)+(C8>D8))*24)

Regards!

Yogi