View Single Post
  #3   Report Post  
Paga Mike Paga Mike is offline
Junior Member
 
Location: Lakehurst, NJ, USA
Posts: 19
Default

Quote:
Originally Posted by View Post
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