Minutes and seconds!

[Guest]

I'm trying to track race times in minutes and seconds. Then average the times on a weekly and monthly basis.

What's the correct 'format'?

Any help?

 

[Derek]

Hi
Try custom format [m]:ss
You still have to enter zero hours, eg
250 minutes and 40 seconds is entered as
0:250:40

Derek
This message was edited by Derek on 2002-02-24 18:44

 

[Anne Troy]

Using just straight numbers, with your minutes in column A and your seconds in column B, (and no other numbers in those columns) I worked this out:

=SUM((SUM(A:A)*60+SUM(B:B))/60)/10

No worry about entering proper *times*.

 

[Derek]

Dreamboat
I used this formula
=SUM(A:A)+TRUNC(SUM(B:B)/60)&"."&MOD(SUM(B:B),60)

Apologise if I'm wrong but I don't think you need the /10 at the end of your formula
regards
Derek

 

[Anne Troy]

Well, I used the 10 to do the AVERAGE of the 10 cells on which my formula was based. Yes?

I sum the minutes, convert them to seconds, add to the *real* seconds, then divide by 60 to come up with minutes again, then divide by 10 to come up with the average.

_________________
TheWordExpert
This message was edited by Dreamboat on 2002-02-24 20:01

 

[Derek]

Ah, I see, I didn't realise you were averaging 10 entries.
Derek