Just try this.

=TEXT(A1-A3,"h:mm:ss")

If this post helps, Click Yes!

--------------------
(MS-Exl-Learner)
--------------------



"Scott" wrote:

I have a column of times and would like to calculate the time differences
between two times. I tried to use = B3-B2 to find out the time difference
without success. Can someone advise the correct formula used in Excel 2007.

Thanks,

Scott