Minutes and seconds!

Feb 24th, 2002, 07:05 PM

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 · Feb 24th, 2002, 07:38 PM

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 · Feb 24th, 2002, 07:46 PM

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 · Feb 24th, 2002, 08:29 PM

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 · Feb 24th, 2002, 09:00 PM

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 · Feb 24th, 2002, 09:12 PM

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

Feb 24th, 2002, 07:46 PM	#3
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	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*. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 24th, 2002, 07:05 PM	#1
Guest Posts: n/a	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?

Feb 24th, 2002, 07:38 PM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	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 ]

Feb 24th, 2002, 08:29 PM	#4
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	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

Feb 24th, 2002, 09:00 PM	#5
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	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 ]

Feb 24th, 2002, 09:12 PM	#6
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Ah, I see, I didn't realise you were averaging 10 entries. Derek