Is it possible to add TIMES and calculate the average on Microsoft Excel?

Don't change them to seconds at all. Just sum them. With the correct formatting they will add just fine.

You could create separate columns for minutes and seconds, and then write a formula that converts to seconds, then back again. There should be a simpler solution, but once you set that up, it would all be automated.

=AVERAGE(cell:cell)

Your average is 4:43.

Basically you are averaging time of day. No tricks needed.

Alan

highlight all the cells you will be using in a time format and then select FORMAT - Cells - Time and select the format that looks like this: 00:00:00

Now enter the times in those cells, such as 0:04:42, and the in another cell sum them using the Sum symbol and then divide that answer by the number of times.

You can combine these two steps by going to the cell you with your sum and adding /6 (in your example) after the end of the sum formula.

Make sure the cell you sum and divide in are formated the same way.

Thanks, I've got it working now. Makes it easy to calculate the top-5 average for CC, too. I found an option that allows entering mile times to the tenth (4:45.2) but it won't allow hundreths. Not that it matters in the grand scheme of things.

go to number formating and choose "custom". You can have it report hundreths if you want just put two zeros after the decimal point.

out of ideas wrote:

found an option that allows entering mile times to the tenth (4:45.2) but it won't allow hundreths. Not that it matters in the grand scheme of things.

HERETIC!!!!

m:ss.00

easy fix wrote:

go to number formating and choose "custom". You can have it report hundreths if you want just put two zeros after the decimal point.

I tried that but it didn't work. When I tried to change the decimal point it ruined the min:sec setup.

If it's cross country, then hundredths would give a false sense of precision anyway. Hand timing isn't that precise, and who on earth gets chip timing to the hundredth for splits in a cross race?

I'm not real familiar with excel as I have never used it. If I want to add a list of 20 or so things together I have to use a calculator to add them up. Can someone easily explain to me how I could add them up on excel? I think you can highlight the whole thing and then put in some code somewhere. Thanks guys, I can't believe how far behind the times I am getting...lol

MTH wrote:

highlight all the cells you will be using in a time format and then select FORMAT - Cells - Time and select the format that looks like this: 00:00:00

Now enter the times in those cells, such as 0:04:42, and the in another cell sum them using the Sum symbol and then divide that answer by the number of times.

You can combine these two steps by going to the cell you with your sum and adding /6 (in your example) after the end of the sum formula.

Make sure the cell you sum and divide in are formated the same way.

Thank you for that. Very useful.