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

M

Matt75

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.
 
D

Dave Peterson

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

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