| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I calculate the average of a list of time values in excel
I have a list of time values that I need to calculate the average, in excel.
I am having issues coming up with a correct average. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I calculate the average of a list of time values in excel
The average function should work, but it also depends on how much 'time' you
are averaging. Can you give us some examples of incorrect results? Verify please the formatting of the cells you are averaging. -- John C "gbray" wrote: I have a list of time values that I need to calculate the average, in excel. I am having issues coming up with a correct average. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I calculate the average of a list of time values in excel
The most obvious answer is
=AVERAGE(A1:A20) In what way are you failing to get a 'correct' average? What value do you get? what value did you expect to get? What are your data? Mike "gbray" wrote: I have a list of time values that I need to calculate the average, in excel. I am having issues coming up with a correct average. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ignore MAX and MIN values in a set to calculate average | Excel Discussion (Misc queries) | |||
| Calculate the average of numbers, ignoring multiple values | Excel Discussion (Misc queries) | |||
| Calculate average and not include zero values | Excel Discussion (Misc queries) | |||
| Looking-up Columns w/calc'd Values ONLY to Calculate Average | Excel Worksheet Functions | |||
| How do you calculate average time? | Excel Discussion (Misc queries) | |||
Hybrid Mode
