Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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????? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Program for assigning work shift hours | Excel Discussion (Misc queries) | |||
IS THERE A FORMULA TO MAKE E=6:00PM ETC SHIFT TIMES AND HOURS | Excel Worksheet Functions | |||
How are relay leg times or driving times entered and totaled? | Excel Worksheet Functions | |||
Subtracting lunch breaks from different shift times | Excel Discussion (Misc queries) | |||
How do I turn off Mouse Scroll in Excel(Shift key 5-times)? | Excel Worksheet Functions |