Thread: Average Time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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