D
Dale G
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).
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).