| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Adding Times
How do I add times for a night shift i.e., 7:00 PM to 7:00AM.
|
|
#2
|
|||
|
|||
|
Hi!
A1 = start time - 7:00 PM B1 = end time - 7:00 AM =B1-A1+(A1B1) Format as h:mm = 12:00 =(B1-A1+(A1B1))*24 Format as GENERAL = 12 Biff -----Original Message----- How do I add times for a night shift i.e., 7:00 PM to 7:00AM. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
| Formula for averaging times | Excel Discussion (Misc queries) | |||
| Adding times together | Excel Worksheet Functions | |||
| SUMPRODUCT ON TIMES | Excel Worksheet Functions | |||
| Adding/Averaging Times in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
