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?