View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jon M Jon M is offline
external usenet poster
 
Posts: 24
Default Assigning times to shift

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?????