Thank you so much for your quick reply! Actually, I needed average
Hours/Minutes/Seconds
I think the calculation is close, but it gave me

930202 day(s) & 12:56

Can you help one more time? Thanks so much!

"מיכאל (מיקי) אבידן" wrote:

HTH:
=TEXT(INT(AVERAGE(A:A)),"#")&" day(s) & "&TEXT(MOD(AVERAGE(A:A),1),"hh:mm")
Micky


"Kila" wrote:

I have a column of data that is in the following format:

2:37:56 (2 hours:37 minutes:56 seconds)

How can I have the summary cell display an average days/hours/minutes for
the entire column? Thanks.