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'
Click to expand...


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

Thanks again,
Peter
 
Back
Top