| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for shifts from times
What i have: A very long column entered in the HH:MM AM/PM format in pacific
standard time (PST). eg. 4:15 AM. What i need: 1. I need those times to be changed from pacific standard time (PST) to Eastern standard time (EST) 2. and then those hours to be changed into shifts (via Formula?) My shifts a Shift 1 = 8:00 AM to 4:00 PM Shift 2 = 4:00 PM to 12:00 AM Shift 3 = 12:00 AM to 8:00 AM I would greatly appreciate any help. -- thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing times into shifts | Excel Discussion (Misc queries) | |||
| End of month help with shifts | Excel Worksheet Functions | |||
| More column shifts ... | Excel Discussion (Misc queries) | |||
| Set up schedule for 3 different shifts | Excel Discussion (Misc queries) | |||
| formula for - price times discount times tax = final price | New Users to Excel | |||
Threaded Mode
