View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How do I add a list of times to get an average time?

=average(a1,b3,c9)
or
=average(a1:a3)

You may want to format the cell as: [hh]:mm:ss



Matt75 wrote:

I am doing a study of the time it takes to process a form. The form goes
through three stations. I have "total time to process" at the end. I would
like to add these times and determine an average time to process a form. How
is this done? I have tried different formatting with no success. I am using
Office 2003.


--

Dave Peterson