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

[Guest]

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!

 

[Bob Phillips]

=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)