Biff & JG,

Thank you both so very much for all your help!!! After some minor tweaking
of your suggestions, I have the formula working just the way I want it. Now I
have a new, minor dilema. My company has added Sunday hours and an idea I
originally wanted to incorporate (scheduled to work less than 6 hours = 0
time for lunch) really comes into play, as we will only be open 4 hours on
Sunday's. Also, do either of you know of an easy way of copying a validated
cell to new cells. The process I used was very cumbersome; validating each
cell. Once again, any help you can offer will be greatly appreciated.

Paul

"Paul" wrote:

Recently, you helped me out on the Microsoft Office discussion board, and
that was greatly appreciated. I need to take this scheduling spreadsheet to
the next level, though, and I was hoping to impose upon you one more time for
some help. The following formula is currently being used to figure the number
of hours worked daily less a 30 minute lunch:

=IF(COUNT(B3:C3)<=0,0,TEXT((C3-B3)-TIME(0,30,0),"h:mm"))

Here's where I really need the help. I would like to work something into the
formula for the following info:

work 5.5 hours or less = no lunch

work 9 - 9.75 hours = 45 minute lunch

work 10 or more hours = 60 minute lunch

The 5.5 hours worked formula is not as important to me as the others, but it
would be nice to have.

Please let me know if there is any other info you might need, or if you even
want to take this on.

Thank you,

Paul