What sort of times do you have, clock times, i.e. the time something
happened, or elapsed times, e.g. for a running race, for instance?

"Roger Govier" wrote:

Hi Peter

Just use
=AVERAGE(A1:A10) where A1:A10 hold your times.
Format the cell with formula FormatCellsNumberCustom[hh]:mm:ss to
allow for an average which exceeds 24 hours.

--
Regards

Roger Govier


"PeterM" wrote in message
...
I would like to take the average of a list of times in the format
HH/MM/SS
but I get gibberish.
Why is this and how do I return and average value from this data set
with
the format HH/MM/SS?