Averaging Time withing Excel

R

RamblingWreckGT

I have a column of data that is mm:ss . I am wishing to have Excel Average
the times. I have had no suceess by formating the column as mm:ss and then
performing the function. I countunualy get the result of #DIV/0!.
Note: I am using Office 2000
Help!!
 
F

Fred Smith

What formula are you using to do the averaging?

Are you sure your cells have valid Excel times in them, or do they have text
masquerading as times?
 
R

RamblingWreckGT

the data in the cell is, for example, 10:23

and the average funchtion I am using is =AVERAGE()
 
D

David Biddulph

the data in the cell is, for example, 10:23

and the average funchtion I am using is =AVERAGE()
Click to expand...

The question Fred asked was:
"Are you sure your cells have valid Excel times in them, or do they have
text masquerading as times?"

Have you looked at the format of the cells in question?
Have you tried =ISTEXT(A1) or =ISNUMBER(A1)?

If you've got text, change the format of the cells to time, then put a zero
in a spare cell, copy that cell, select the cells you want changing to time,
then paste special/ add.
 
Top