Another Time Related Question
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. |
Another Time Related Question
On Tuesday, September 11, 2012 10:15:13 PM UTC+2, (unknown) 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. =TEXT(B1-A1;"hh:mm:ss") |
Quote:
hh:mm:ss If you anticipate a negative result, you should use the 1904 Date system |
Another Time Related Question
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 ? |
Quote:
-0:00:35 |
Another Time Related Question
try =TEXT((A-B),"[s]") On Tuesday, 11 September 2012 21:15:13 UTC+1, (unknown) 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. |
1904 date system is turned on for a workbook under
options-advanced-When calculating this workbook. I had to search for it so I thought I would save other people the trouble ;) |
Quote:
|
All times are GMT +1. The time now is 09:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com