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