+ Reply to Thread
Results 1 to 4 of 4

Calculate time to cover a distance

  1. #1
    Registered User
    Join Date
    09-22-2009
    Location
    Mumbai India
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    77

    Calculate time to cover a distance

    Hi all, this is normally a very simple thing to calculate and I know how to calculate for speed, distance and time or SoDiT as we learnt at school..

    I have a period of time where a distance in feet is covered. Lets say 1 hour 25 minutes to cover 12,600 feet, just over two miles.

    What I need to solve for in this case is not speed exactly, but how long it takes to cover 10 feet in this scenario.

    I start to do the math in excel and then the formatting jumps when I set to hh:mm:ss and I get confused whether I'm multiplying or dividing by 60 and it all becomes a mess.

    Can you help?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,473

    Re: Calculate time to cover a distance

    I would disregard the time formatting for this exercise. 1 hour 25 minutes is 85 minutes.

    In A1, 12,500
    In A2, 85
    In A3, = A1/A2
    In A4, = A3*10

  3. #3
    Registered User
    Join Date
    09-22-2009
    Location
    Mumbai India
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    77

    Re: Calculate time to cover a distance

    Hi guys, I'm really struggling with this. It seems so simple and the formatting is causing me great issue.

    I've converted time into decimal units then I lose track of the answer. I need to know how many minutes it takes to cover 10 ft based on the input times and distance. Can anyone help solve for the yellow filled cell attached?
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-22-2009
    Location
    Mumbai India
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    77

    Re: Calculate time to cover a distance

    May have solved this if someone can just confirm?
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    08-04-2014
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    579

    Re: Calculate time to cover a distance

    I believe You miscalculated, it does not take you 36 minutes to go ten feet, in fact it takes you 0.36 minutes. Cheack the file.
    Attached Files Attached Files
    Last edited by bmouse; 08-07-2014 at 05:30 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate distance ran using time vs program
    By cls1983 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2013, 11:52 AM
  2. how could I calculate ave. speed from time and distance
    By Peterlckwd in forum Excel General
    Replies: 4
    Last Post: 04-12-2012, 07:56 PM
  3. Replies: 7
    Last Post: 12-18-2008, 01:41 AM
  4. [SOLVED] How to calculate speed given distance and mm:ss time format?
    By rrl in forum Excel General
    Replies: 1
    Last Post: 10-21-2005, 01:05 PM
  5. [SOLVED] calculate time/distance
    By KJO in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2005, 05:06 PM

Tags for this Thread

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