using excel, how do i subtract 1 time (mm:ss.ss) from another? these are swim times, (1:33.54 - 1:23.45 = ???

Question

using excel, how do i subtract 1 time (mm:ss.ss) from another? these are swim times, (1:33.54 - 1:23.45 = ???

Answer 1

assume:

A1: 1:33:54

B1: 1:23:45

Formula in cell C1 : =(A1-B1)*1440

( 24 hours*60 minutes=1440 )

Format in cell C1 : regular number format



Result : 10.5 minutes



edit:

=ABS(A2-A1)

result 0:10.09



Hope this helps,

Good luck.

Answer 2

Using the same format you are using



cell a1= first time

cell a2=second time



Any cell you wish to use for the result would have the formula:

=a1-a2

Answer 3

I would simplify it and convert it to seconds...93.54 - 83.45 which is

Cell A1 93.54

Cell A2 83.45

Cell A3 =SUM(A1-A2)

Answer 4

Use a calculator