"RamblingWreckGT" wrote in
message ...

"Fred Smith" wrote:

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?

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

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

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.
--
David Biddulph