Thanks:  0
Likes:  0

1. 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?

2. 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 ]

3. 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*.

4. 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

5. 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 ]

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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•