G gbray Aug 12, 2008 #1 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.
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.
J John C Aug 12, 2008 #2 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.
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.
M Mike H Aug 12, 2008 #3 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
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
