Just use

=AVERAGE(A:A)

and format as time also

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Brento" wrote in
message ...

Hi All,

I am having diificulty reading a columb of data reading different
lenghts of time in this format 00:25:06 and 00:42:46 etc

I am looking to find the average but have no luck as i have imported
the data.

please help

thanks
Brento


--
Brento
------------------------------------------------------------------------
Brento's Profile:
http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=526896