Formula for working out minutes per mile.

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Formula for working out minutes per mile.

  1. #1
    New Member
    Join Date
    Jun 2002
    Location
    Peterborough
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Formula for working out minutes per mile.

     
    I have been asked to set up a formula for working out minutes per mile. For instance if a person runs for 20 minutes at a speed of 6.4 miles per hour and covers a 2.13 miles then the minutes per mile should be 9.23 (according to a website i found) however i tried to work out how the website works this figure out. Has anyone got any suggestions please.
    Cheers
    Will
    :o

  2. #2
    Board Regular Chitosunday's Avatar
    Join Date
    Jul 2003
    Posts
    1,017
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Isn't the minute per mile equals to 9.375computed as

    =60/6.4
    or
    =20/2.13
    Mr Young at Heart - Learning is like chasing the wind, it's boundless.

  3. #3
    MrExcel MVP Richie(UK)'s Avatar
    Join Date
    May 2002
    Location
    UK
    Posts
    3,329
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula for working out minutes per mile.

    Hi Will,

    Like this:


    ******** ******************** ************************************************************************>
    Microsoft Excel - Book1___Running: xl97 : OS = Windows ME
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    A
    B
    C
    D
    1
    Distance
    Travelled
    Time
    Taken
    MPM
    2
    2.1300:20:0000:09:23
    Sheet1

    [HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.



    HTH
    Richie

  4. #4
    New Member
    Join Date
    Jun 2002
    Location
    Peterborough
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula for working out minutes per mile.

    .....yes that worked it out just fine didn't it. hmmm need to practice simplicity more.... thanks

  5. #5
    Board Regular Chitosunday's Avatar
    Join Date
    Jul 2003
    Posts
    1,017
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Oh , i see. Richie discovered that it is 9 minutes and 23 seconds (formatted as "h:mm:ss") and not 9.23 minutes
    Mr Young at Heart - Learning is like chasing the wind, it's boundless.

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
  •  

 

 
DMCA.com