Averaging Time

[PeterM]

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?

 

[galimi]

Peter,

If you are summing dates that are already in HH:MM:SS format, you will
likely run into a challenge when you exceed 24 hours as the clock will then
roll. If you are using whole numbers, like 8, to designate 8 hours and are
displaying that in date format, you are not going to see 8 hours, but zero,
the rollover of 8 days.

 

[Roger Govier]

Hi Peter

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

 

[David Biddulph]

If you've got times rolling over beyond the 24 hour mark, use the cell
format [h]:mm:ss.

 

[daddylonglegs]

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?

Hi Peter

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

--
Regards

Roger Govier

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?