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" wrote in message
...
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