+ Reply to Thread
Results 1 to 2 of 2

Calculating MPH from distance and time.

  1. #1
    Registered User
    Join Date
    04-28-2009
    Location
    Columbia, MO
    MS-Off Ver
    Excel 2003
    Posts
    6

    Calculating MPH from distance and time.

    Hello all, I have made another worksheet to keep track of my running. I collect steps, time in hours and minutes which is added for a total time in minutes, and distance. I am trying to figure my miles per hour from the distance and time, but I get the number .05 from 3.44 miles in 1 hour and 8 minutes. How can I get this number to display right?

    I am using MPH=distance/time; Am I wrong on this one?

    Thank you all for any help.

    Kevin

  2. #2
    Registered User
    Join Date
    04-28-2009
    Location
    Columbia, MO
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Calculating MPH from distance and time.

    Never mind, I forgot to multiply by 60...

    Sorry for the inconvenience.

    Kevin

+ 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