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.