Results 1 to 5 of 5

Formula for working out minutes per mile.

This is a discussion on Formula for working out minutes per mile. within the Excel Questions forums, part of the Question Forums category; I have been asked to set up a formula for working out minutes per mile. For instance if a person ...

  1. #1
    New Member
    Join Date
    Jun 2002
    Location
    Peterborough
    Posts
    48

    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

    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,330

    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

    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

    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.

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