| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I calculate and show negative time in Excel?
I need to calculate and show lost time e.g
Expected arrival 1:15:00 Actual arrival 2:10:00 Time lost is Actual - Expected = -0:50:00 |
|
#2
|
|||
|
|||
|
The calculation is working, the display is not working. Not your fault.
Try Tools Options... Calculate and then make sure the 1904 date system is checked Good Luck -- Gary''s Student "Ramonak" wrote: I need to calculate and show lost time e.g Expected arrival 1:15:00 Actual arrival 2:10:00 Time lost is Actual - Expected = -0:50:00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I calculate negative numbers to = zero in excel? | Excel Discussion (Misc queries) | |||
| show elapsed time ? | Excel Discussion (Misc queries) | |||
| Calculating negative time & creating scrol bars for fixed size txt box. | Excel Discussion (Misc queries) | |||
| How to show negative time (e.g. -10 hours) | Excel Worksheet Functions | |||
| calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
Linear Mode
