Average Time...

  • Thread starter Thread starter Kevin
  • Start date Start date
K

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?
 
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.
 
Back
Top