# 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

Joined:
Oct 23, 2005
Location:
#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

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

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