use AVERAGE

=AVERAGE(A1:A5)

gave me a result of 00:36

Cells were formatted as mm:ss and data as

00:00:35
00:00:40
etc

"Mashuganah" wrote:

I need to average a list of minutes and seconds in mm:[ss] format (the only
format that would display them properly):
0:35
0:40
0:39
0:42
0:26

Excel 2003 SP2 is giving 1:00 rather than 00:36. How do I get Excel to do
this correctly?