pace calculator

L

Lise

How do I caluclate running pace? Calculation is Nb of Minutes / Km (or Miles)
but it always return a number in base 60
 
M

Myrna Larson

If you've entered the time as a time (i.e. Excel recognizes it as such), it's
stored as a fraction of a day. With the time in A1 and the distance in A2, the
formula to get Minutes/Distance is =A1*1440/A2. 1440 is the number of minutes
in a day.
 
Top