+ Reply to Thread
Results 1 to 2 of 2

How do I create a formula to calculate pace per mile?

  1. #1
    Registered User
    Join Date
    08-21-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    How do I create a formula to calculate pace per mile?

    I have an Excel spreadsheet to keep track of my training for a race I am going to do. I would love to enter a formula that will calculate my pace per mile. I already have a cell where I enter my distance I ran, a cell where I enter the time it took me to run that distance, and I have a cell to calculate the pace per mile. It is not as simple as dividing the distance by the time taken to run the distance, there is more to it than that, I just don't know what it is :-)

    Let's say in cell D2 is my distance of 4 miles, and in cell E2 is my total time of 45 minutes and 29 seconds, what formula would I enter in F2 to calculate my pace per mile? Do I need to format any of the cells? If so, how?

    I went to an online website that will calculate my pace for me. Running for 4 miles with a total time of 45 min and 29 seconds gives me a pace of 11:22. If I simply divide 45:29 by 4 miles, I get a pace of 11:32. There are 60 minutes in an hour and 100 parts in a whole. You can't compare the two and that is where the confusion comes in.

    Thanks for any help!

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: How do I create a formula to calculate pace per mile?

    cross post @
    http://answers.yahoo.com/question/in...1112532AA6iPE5
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1