Average Time Format

B

Brento

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
 
B

Bob Phillips

Just use

=AVERAGE(A:A)

and format as time also

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
P

Peo Sjoblom

Times is just numbers and can be averages as such, what's the problem you
are having?
If it is that the import is text, format and empty cell to time format, copy
it, select the import and do edit>paste special and select add
 
Top