pace calculator

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I caluclate running pace? Calculation is Nb of Minutes / Km (or Miles)
but it always return a number in base 60
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I convert pace per mile to total time in minutes in excel? 2
Does anyone know how to create a pace calculator (min/mile) in Exc 10
convertion formula for (min/mile) to (mile/hr) 3
Excel - Grid Lookup 1
In Excel, how do I display a leading zero? e.g. 05 for 5 ? 1
copying & averaging formulas 6
Adding the resulting intersection to an If statement. 1
Convert time to running pace per mile 3

Back
Top