Excel Formula Needed - Distance/Time/Speed

[zw-gator]

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

 

[dukebound85]

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

 

[kmaute]

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