| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shift Information
How can I write a formula to display shift(1,2,3) in shift column by given
time? Time Shift 08:12:10 ? 15:30:15 ? 23:55:02 ? Condition Shift 1 is time = '07:00' AND time < '15:00' Shift 2 is time = '15:00' AND time < '23:00' Shift 3 is time = '23:00' AND time < '07:00' Regards, Tee |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Shift Information
See response in public.excel
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "engteng" wrote in message ... How can I write a formula to display shift(1,2,3) in shift column by given time? Time Shift 08:12:10 ? 15:30:15 ? 23:55:02 ? Condition Shift 1 is time = '07:00' AND time < '15:00' Shift 2 is time = '15:00' AND time < '23:00' Shift 3 is time = '23:00' AND time < '07:00' Regards, Tee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table cutting information of a part of the information | Excel Discussion (Misc queries) | |||
| Information dependent on other information | Excel Programming | |||
| Replace information based on existing information | Excel Programming | |||
| How 2 use right shift "<<" and left shift "" operator in excel? | Excel Programming | |||
| How 2 rotate information in a working shift pattern | Excel Worksheet Functions | |||
Linear Mode
