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")