Average HH:MM:SS

[steve99]

Thanx for the response....!

In this example I have a series of 12 times. They are formatte
HH:MM:SS hour, minute, second. Thus, the first value is 0 hours,
minutes & 44 seconds. I need to find what the average time is fo
these 12 times. ie. I need to sum these 12 times and divide by 12 o
just use the average function. I can do averages easily with ra
numbers. However, when I have data in time format (HH:MM:SS) th
result of sum or average for the row of 12 times gives me div/0. I a
wondering if there is another function that I don't know about or if
need to convert the data to another format, do the average, the
convert back to the time format I need.

Does that shed any light?

Cheers!

Stepeh

 

[Alan]

It doesn't for me, as I said =AVERAGE(A1:A12) returns a result. I dont
really know what's happening at your end. Send me the file if you want to,
I'm interested as to what's occurring. Replace 111 with 8202 in my address,
Regards,