Funcation to average the Time spent
 

Hi,
I am unable to get the right function to find the average time of 10 cells
The time is in dd:hh:mm format,like 0:0:03.

Any help in this regard is higly appreciated

Regds
Subbu

=AVERAGE(A1:A10) and format as time

--

HTH

RP
(remove nothere from the email address if mailing direct)


"subbu" wrote in message
...
Hi,
I am unable to get the right function to find the average time of 10
cells
The time is in dd:hh:mm format,like 0:0:03.

Any help in this regard is higly appreciated

Regds
Subbu