| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
24 hour time sheet
I have to do a time sheet with 10 people on it, some work night and some work
days.The days are no problems but when it come to the night shift they start at 1800 and finish the next day at 0600. I need a formula that will be able to do both as they rotate between nights and days. I want it to do both without having to re format everytime that they change from nights to days Can anyone help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i add an hour to a time column | Excel Worksheet Functions | |||
| how to calculate time start & time finish in quarter hour | Excel Discussion (Misc queries) | |||
| making a time a measurement of time, not an hour of the day?? | Excel Discussion (Misc queries) | |||
| 3.10 PM to 24 hour time please ( 1510 ) | Excel Worksheet Functions | |||
| convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
Threaded Mode
