| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| elapsed time average calculcations | Excel Discussion (Misc queries) | |||
| How do I compare two times to see if one is "late" or "on time"? | Excel Worksheet Functions | |||
| Adding time | Excel Discussion (Misc queries) | |||
| unmet challenge | Excel Worksheet Functions | |||
| Formula for averaging times | Excel Discussion (Misc queries) | |||
Linear Mode
