Finding the average time...

[McDeath]

<FONT FACE="Tahoma, Arial" Size=-1>
Nice site, this is my first post.

I am using Excel 2000 and want to find the average time of multiple cells. Time is stored in each cell in the format xx:xx (minutes:seconds)

What can I do to find the average time? If I have to change the time format it's no big deal.

Does that make sense?

Thanks... //cDeath
This message was edited by McDeath on 2002-10-25 14:29

 

[plettieri]

Hello:

Might want to try this site for good explaination and defitions of time and date
http://www.mvps.org/dmcritchie/excel/excel.htm


also good examples

pll

 

[Aladin Akyurek]

On 2002-10-25 14:27, McDeath wrote:<FONT FACE="Tahoma, Arial" Size=-1>
Nice site, this is my first post.

I am using Excel 2000 and want to find the average time of multiple cells. Time is stored in each cell in the format xx:xx (minutes:seconds)

What can I do to find the average time? If I have to change the time format it's no big deal.

Does that make sense?

Thanks... //cDeath
This message was edited by McDeath on 2002-10-25 14:29

=AVERAGE(Range)

Custom format the cell as [mm]:ss.