Hi,

Try this,

=LOOKUP(24*A1,{1,7,15},{"Night","Day","Night"})

This will give 2 shifts 07:00 - 15:00 = days
all other time nights
I think you should be able to work out how to do it if you want 3 or 4
different shifts.

Mike

"Jon M" wrote:

Working with spreadshift containing date and times of events during a one
month period. I converted the cell content from date and time to time (23:00
format).

Now I want to go back and associate events with a given shift, i.e., If
B2=(7,0,0) AND time <=(15,0,0), "Days" (or it could just be a value, ie.,
1)

If I want to assign the value to one of three shifts, can I just string all
three formulas together and separate with commas?

Keep getting formula error.
Arghhh.

Thanks in advance for any help.
Help?????