Average time for a race in minutes seconds & tenths

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

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




"Gammalite" <Gammalite@discussions.microsoft.com> wrote in message
news:28C3B2A1-7F01-4534-B420-8414E57E4916@microsoft.com...
> 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