Average Time Format
 

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

Average Time Format
 

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

Average Time Format
 

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 editpaste special and select add


--

Regards,

Peo Sjoblom


"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