Average Time Format

[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

[Bob Phillips]

Just use

=AVERAGE(A:A)

and format as time also

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Brento" <Brento.25cnbm_1143498301.1465@excelforum-nospam.com> wrote in
message news:Brento.25cnbm_1143498301.1465@excelforum-nospam.com...
>
> 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
>

[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


--

Regards,

Peo Sjoblom


"Brento" <Brento.25cnbm_1143498301.1465@excelforum-nospam.com> wrote in
message news:Brento.25cnbm_1143498301.1465@excelforum-nospam.com...
>
> 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
>