How do I calculate running pace?

F

Forrest

I have time entered in the form: hh:mm:ss and distance in kilometres. I am
trying to calculate my pace in the form: minutes per kilometre. Problem is
that Excel interprets any digits entered as time to be "time of day" as
opposed to a cumulative time. Therefore, when I try to calculate
time/distance, I get a blank cell (no error message).
 
J

JE McGimpsey

XL makes no distinction between time of day and elapsed time - they're
both stored as fractional days, regardless of display format, so

03:00:00 = 03:00:00 AM = 0.125

To get minutes per kilometer, with say, 8 km in 20 minutes:

A1: 0:20:00
A2: 8
A3: =A1/A2

format A3 with

Format/Cells/Number/Custom m:s/k\m
 

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
what is the formual for calculating running pace? 4
In Excel, how do I display a leading zero? e.g. 05 for 5 ? 1
Cumulative days roll-over 7
Excel does not accept text format! 0
Duration of time 6
Does anyone know how to create a pace calculator (min/mile) in Exc 10
How do I calculate Track and Distance from two sets of coordinate 2

Top