View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] cmiedaner@msn.com is offline
external usenet poster
 
Posts: 29
Default 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.