how to substract two times in the cell

[awu10]

Hi, All:
I need to calculate difference between two times in the cell. For example,
C1 cell has 13:23:34
C2 cell has 13:23:38

The difference in my application is from seconds to minutes. Would someone tell me how to calculate this difference in detail?

Thank you
awu10

[swatsp0p]

I will assume your Time cells are formatted as Time: hh:mm:ss

If your times are in cells C1 and C2, in C3 place this formula:

=C2-C1 and make sure this is also formatted as hh:mm:ss

In your example:
C1 | 13:23:34
C2 | 13:23:38
C3 | 0:00:04

The result is 4 seconds difference

HTH

Bruce