How do I add a list of times to get an average time?
 

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.

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