# 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. ## 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. Isn't the minute per mile equals to 9.375computed as

=60/6.4
or
=20/2.13

3. ## 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
 C2 =

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

4. ## 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. Oh , i see. Richie discovered that it is 9 minutes and 23 seconds (formatted as "h:mm:ss") and not 9.23 minutes

#### Posting Permissions

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