Excel Formula Needed - Distance/Time/Speed

Discussion in 'Mac Apps and Mac App Store' started by zw-gator, Aug 8, 2009.

  1. zw-gator macrumors 6502a

    zw-gator

    Joined:
    Oct 23, 2005
    Location:
    Canada
    #1
    I track all my runs in an excel spreadsheet.

    I've been using this site to calculate my speed, but I'm getting lazy and would rather excel calculate it automatically.

    I know my time and distance

    I want to figure out my:

    km/h
    time to run 1km
    miles/h
    time to run 1 mile

    For this example, lets say distance is in A1, time is in B1, and the rest are getting inputed into C1-F1
     
  2. dukebound85 macrumors P6

    dukebound85

    Joined:
    Jul 17, 2005
    Location:
    5045 feet above sea level
    #2
    in your equation, convert your distance to km , then time to hrs and then ratio that to get km/hr

    then take the inverse to get the time to run 1 km
     
  3. kmaute macrumors 6502

    kmaute

    Joined:
    Oct 5, 2008
    Location:
    USA
    #3
    Put your distance in decimal KM and time in decimal minutes (i.e. 15 minutes, 45 seconds would be 15.75)

    KM/h or c1 =a1/(b1/60)
    Time to 1 KM or d1 = 60/c1

    MP/H or e1 =c1/0.621371192
    Time to 1 mile or f1 = 60/e1
     

Share This Page