Question about "average" function

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Hi,

I know how to use the "average" function to get the average of a row
of numbers. I don't know how to get the average of a row of times (ex.
2:32 1:15 4:10). Is there any way of doing it other than adding them
up and dividing by the total number?

Thank you for any help,

Peter
 
Are you certain you're working with actual TIMES (in Excel's eyes?). I
averaged those up just fine, it came to 2:39. The actual cell *contents*
appeared like 4:10:00 AM and it looked like 4:10 on the worksheet.
 
Hi Peter
=AVERAGE(your_range_with_times)
and format the target cell as 'Time'


Thanks to all who answered for the help. I figured out what I did
wrong and fixed it.

Thanks again,
Peter
 

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

Back
Top