Average Time...

[Kevin]

I've got the cells formatted with "Custom" and m:ss.
I'm using the formula:
=AVERAGE(F10:F15)
and it gives #DIV/0

Is there any way to keep the times in minutes:seconds format and still
get the average?

 

[JE McGimpsey]

Sounds like your times are actually entered as Text. Try this: Select an
empty cell. Copy it. Select F10:F15. Choose Edit/Paste Special,
selecting the Add and Values radio buttons. As long as you have at least
one non-zero value in the range, that should give you an average.