| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shift Schedule Formula
Hello. Need a formula that will return the shift name (A/E/C/F) in cell A2
based on the current system date and time. I am not sure how to make it happen. My shift schedule is below: A-Shift: 07:00 to 19:00 Sunday, Monday,Tuesday and every other Wednesday C-Shift: 07:00 to 19:00 Every other Wednesday, Thursday, Friday and Saturday E-Shift: 19:00 to 07:00 Every other Saturday, Sunday, Monday and Tuesday F-Shift: 19:00 to 07:00 Wednesday, Thursday, Friday and every other Saturday Is this possible? Thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for shift schedule & calculating future dates - 2003 | Excel Discussion (Misc queries) | |||
| how do i create a work shift schedule | Excel Discussion (Misc queries) | |||
| Shift Schedule Spreadsheet | Excel Discussion (Misc queries) | |||
| Employees shift schedule | Excel Discussion (Misc queries) | |||
| Change formula for Employee Shift Schedule template | Excel Worksheet Functions | |||
Threaded Mode
