Quote:
Originally Posted by
On Wednesday, September 12, 2012 8:42:47 AM UTC-4, Paga Mike wrote:
;1605406 Wrote: I have 2 times: A) 4:12:31 PM B) 4:07:45 PM In a cell I have the formula (TimeB - TimeA). The cell displays a strange number as a result - 23:55:14. I was hoping it would display the actual time difference (negative or positive). Is that possible ? Thanks in advance. Format the result cell as: hh:mm:ss If you anticipate a negative result, you should use the 1904 Date system -- Paga Mike
Thanks All. I tried what was suggested but still get this result:
A) 11:21:49
B) 11:21:14
B - A = 23:59:25
Any thoughts ?
|
With the 1904 Date system switched on I get:
-0:00:35