| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating time past midnight.
I'm trying to write a formula that will calculate my employees' total time
worked. A problem arises when I have people scheduled to work past midnight. If, say, someone works from 9 pm until 3 am, how do I get Excel to recognize the change in dates and properly figure the time? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to calculate time difference crossing midnight | Excel Worksheet Functions | |||
| subtraction off time after midnight | Excel Worksheet Functions | |||
| Calculating Time Past Midnight | Excel Worksheet Functions | |||
| Calculating time interval (some across midnight) | Excel Worksheet Functions | |||
| Calculating time difference over midnight! | Excel Discussion (Misc queries) | |||
Threaded Mode
