Average Time
Enter the values as real times in A1 and A2
0:03:03
0:01:13
and use a formula like:
=average(a1:a2)
and give it a nice format
[mm]:ss
????
Karen wrote:
How do I go about averaging the following?
Cell A1 = 3 min. 3 sec.
Cell A2 = 1 min. 13 sec.
What formula would I use to average the two?
ANY help would be greatly appreciated, Karen
--
Dave Peterson
|