Average time...

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?
 
A

Aladin Akyurek

F10:F15 probably does not house true time values. You can check whethe
this is so with...

=ISNUMBER(F10)
 
K

Kevin

It is not a true number. What would you suggest? I could convert it
to seconds before entering the data

4:32 = 272 seconds

and then get the average and convert it back. That makes the report
difficult to look at. I'm open to suggestions...
 
A

Aladin Akyurek

Copy an unused, empty cell (whose format is General).
Select F10:F15.
Run Edit|Paste Special with the Operation option set to Add.
Format F10:F15 now as time.

The AVERAGE formula will work as intended.
It is not a true number. What would you suggest? [...
Click to expand...
 
K

Kevin

When I do the "Paste Special" it turns my pretty little time of "2:18"
to "0.095833" which is meaningless to look at.

Copy an unused, empty cell (whose format is General).
Select F10:F15.
Run Edit|Paste Special with the Operation option set to Add.
Format F10:F15 now as time.

The AVERAGE formula will work as intended.
It is not a true number. What would you suggest? [...]
Click to expand...
Click to expand...
 
A

Aladin Akyurek

Your "pretty little time" has now become a true time. You can format
such values as time via Format|Cells.
When I do the "Paste Special" it turns my pretty little time of "2:18"
to "0.095833" which is meaningless to look at.

Copy an unused, empty cell (whose format is General).
Select F10:F15.
Run Edit|Paste Special with the Operation option set to Add.
Format F10:F15 now as time.

The AVERAGE formula will work as intended.
It is not a true number. What would you suggest? [...]
Click to expand...
Click to expand...
Click to expand...
 
Top