How can I calculate the average of a list of time values in excel

G

gbray

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

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

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
 
Top