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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
Sumproduct in matrix means 3
Excel Average dates help 0
Average time values 3
Average values in date range 5
Using the VLOOKUP function to find an Average 2
Average time 15
Subtotal across a row 1

Top