Excel – Calculating Time Difference in hh:mm:ss format

date timemicrosoft excelworksheet-function

I have time format of hh:mm:ss in one cell and the same formatted time in other cell .

I calculate the difference of these two cell and get hh:mm:00 as my difference.

What I request if someone can help me to get the time difference as calculated with hours:minutes and also seconds as well.

Best Answer

How are you calculating the difference?

If you use subtraction like this in C2

=B2-A2

assuming later time in B2

then format C2 as hh:mm:ss you should get the correct difference including seconds - I assume both times are on the same day?

Related Question