Question about "average" function

[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

 

[Dave R.]

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.

 

[Frank Kabel]

Hi Peter
=AVERAGE(your_range_with_times)
and format the target cell as 'Time'

 

[Peo Sjoblom]

It works the same way

=AVERAGE(range_of_times)

 

[Peter]

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