need to convert time format mm:ss to a number

December 1, 2011 at 07:27:31
Specs: Windows 7
Convert mm:ss to number format to be able to calculate average time ex.

A1=00:57
A2=01:06
A3=03:10

A4= AVERAGE A1:A3


See More: need to convert time format mm:ss to a number

Report •

#1
December 1, 2011 at 08:50:27
Try this:

Custom Format you time cells as: [H]:MM:SS then do your average:


        A
1)  0:57:00
2)  1:06:00
3)  3:10:00
4)
5)  1:44:20 <--=AVERAGE(A1:A3)

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question