How do I average a list of times (i.e. "1:30" plus "0:20")?

For instance, if I have a listing of 1:30, 0:20, 2:20, 0:03, and 1:30
(representing minutes and seconds), how do I obtain the average minutes and
seconds of these 5 numbers? Thanks!

=AVERAGE(A1:E1)

time is just held as a number, so average it as you would any numbers, just
format the result cell as time also.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"LoneRanger" <LoneRanger@discussions.microsoft.com> wrote in message
news:94198113-7AA9-4673-8806-E0D4C6F795F3@microsoft.com...
> For instance, if I have a listing of 1:30, 0:20, 2:20, 0:03, and 1:30
> (representing minutes and seconds), how do I obtain the average minutes
and
> seconds of these 5 numbers? Thanks!