| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert date and time into shift worked?
I need to convert a date and time into a specific letter. I have the date is
in one column and the time is in another, and need a letter output in a third column. I need the conversion to look something like this: Every Sunday,Monday,Tuesday from 07:00 to 19:00= A Every Sunday,Monday,Tuesday from 19:00 to 07:00= E Every other Wednesday from 07:00 to 19:00 toggles between A and C Every Thursday,Friday,Saturday from 07:00 to 19:00= C Every Wednesday,Thursday,Friday from 19:00 to 07:00=F Every other Saturday from 19:00 to 07:00 toggles between A and C |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert date/time to time only in Excel? | Excel Discussion (Misc queries) | |||
| Calculate Total hours worked during workdays within given shift time. | Excel Discussion (Misc queries) | |||
| Figuring time worked, and then separating it into regular time an. | Excel Worksheet Functions | |||
| How do I convert a date&time (yyyy-mm-dd hh:mm:ss) to date only? | Excel Worksheet Functions | |||
| Convert date to length of time in months from set date | Excel Worksheet Functions | |||
Threaded Mode
