Average time for a race in minutes seconds & tenths

[Gammalite]

In Excel 2003: How do I create a formula to determine the average time in
minutes, seconds and tenths. Such as 2 min 1 sec 2 tenths plus 1 min 59 sec
6 tenths would equal 2 min 0 sec 4 tenths. Or, 2:1.2 + 1:59.6 = 2:0.4

 

[Peo Sjoblom]

Enter is as

0:02:01.2
0:01:59.6

then sum or add

=A1+A2

custom format h:mm:ss.0


=AVERAGE(A1:A20)

same thing there

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon