| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
1904 negative time
I would like to use the 1904 date system to calculate positive & negative
time. I have column (c) preset with an scheduled arrival time, and a blank column (D) to enter the actual arrivel time. Column E is set with =D-C for the difference. Column E will always show the negative time of C (e.g -4:50) until I enter the actual arrived time in D. Is there a way to have column E remain blank until I enter the actual time. (Also the negative time in E effects other calulations like Average). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 1900 vs 1904 date functions | Excel Worksheet Functions | |||
| using if statement to subtract 24 hours from time still shows as a negative time from both responses under 24 hours | Excel Worksheet Functions | |||
| convert Excel sheet in 1904 format to 1900 without changing dates | Excel Worksheet Functions | |||
| Calculating time and negative time | Excel Worksheet Functions | |||
| Negative time should be allowed in Excel, eg time difference | Excel Discussion (Misc queries) | |||
![Dale G[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
