Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Minutes and seconds!

  1. #1
    Guest

    Default

    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. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #3
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #5
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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