Data Validation Require Unique Number?
- Average speed
- km/h
- Result
- Finish time
- 50 min
- You entered
- Distance
- 10 km
- You entered
Yes, data validation can require a unique number, but standard spreadsheet validation rules do not enforce uniqueness by themselves. You need a custom formula—typically using COUNTIF—to make a range reject duplicates, and the exact formula depends on whether you are validating a single cell or an entire column.
Formula
The calculator works out your average pace and speed for a run or ride. You enter the finish time in minutes and the distance in kilometers. The first result, average pace, is the time it takes to cover one kilometer (min/km). The second result, average speed, is the distance covered per hour (km/h).
The formulas are:
Average pace = Finish time (min) ÷ Distance (km)
Average speed = Distance (km) ÷ (Finish time (min) ÷ 60)
Where:
- t = finish time in minutes (e.g., 50)
- d = distance in kilometers (e.g., 10)
- pace = minutes per kilometer
- speed = kilometers per hour
Worked Example
Using the default values from the calculator: finish time = 50 minutes, distance = 10 km.
- Pace = 50 ÷ 10 = 5.00 min/km
- Speed = 10 ÷ (50 ÷ 60) = 10 ÷ 0.8333 = 12.00 km/h
So the calculator returns an average pace of 5:00 per kilometer and an average speed of 12.00 km/h.
When to Use This Calculator
Use this calculator to plan training paces, estimate finish times for a target pace, or compare effort across different distances. For example, if you want to finish a 10K in under 50 minutes, you need a pace faster than 5:00 min/km. If you run a 5K in 25 minutes, your pace is 5:00 min/km, which equals 12 km/h.
How to Read the Results
The pace result is shown as a decimal number of minutes per kilometer. For example, 5.50 min/km means 5 minutes and 30 seconds per kilometer (0.50 × 60 = 30 seconds). To convert the decimal part to seconds, multiply by 60. The speed result is straightforward: 12.00 km/h means you cover 12 kilometers in one hour.
In the calculator, the pace output is formatted as a duration (h:mm:ss), so 5.00 minutes appears as 0:05:00. The speed output is a plain number with two decimals.
Common Mistakes and Limitations
- Mixing units: The calculator expects time in minutes and distance in kilometers. If you enter a time in hours (e.g., 1.5) or distance in miles, the result will be wrong. Convert first: hours × 60 = minutes; miles × 1.60934 = kilometers.
- Rounding too early: If you round the pace to 5.0 and then compute speed from that rounded value, you get 12.0 km/h, which is fine here, but for other numbers it can cause small errors. Use the full precision in calculations.
- Zero distance: The formula divides by distance, so a distance of 0 gives an error. Always enter a positive distance.
- Not accounting for elevation or stops: This calculator uses total time and total distance, so it gives average pace including any pauses. It does not adjust for hills or terrain.
Practical Examples
Here are a few real-world uses:
- Training plan: You want to run 8 km in 40 minutes. Enter 40 and 8, and you get 5:00 min/km pace.
- Check a goal: You want to run a half marathon (21.1 km) in under 1 hour 45 minutes (105 minutes). Enter 105 and 21.1 → pace = 4.98 min/km (about 4:59 per km).
- Convert pace to speed: A 6:00 min/km pace equals 10 km/h. Enter 60 and 10, and the calculator shows exactly that.
Frequently Asked Questions
How do I convert pace to seconds per kilometer?
Take the decimal part of the pace in minutes and multiply by 60. For example, 5.75 min/km → 0.75 × 60 = 45 seconds, so 5:45 per km.
What if I know my speed in km/h but want pace?
Pace (min/km) = 60 ÷ speed (km/h). For 12 km/h, 60 ÷ 12 = 5.0 min/km.
Does this work for walking too?
Yes, the same formula applies to walking. A typical walking pace is 12–15 min/km, which corresponds to 4–5 km/h.
Why is the pace shown as 0:05:00 instead of 5.00?
The calculator formats the pace as a duration (hours:minutes:seconds) for readability. 0:05:00 means 5 minutes and 0 seconds per kilometer.
Can I use miles instead of kilometers?
Yes, but you must convert. To get pace in min/mile, enter time in minutes and distance in miles. To get speed in mph, the calculator still works, but the units will be miles and minutes. For example, 50 minutes for 6.2 miles gives 8.06 min/mile and 7.44 mph.
Related
Formula used
in t | Finish time | min | 50 | 0 in d | Distance | km | 10 | 0 out pace | Average pace | min/km | t / d | 2 out speed | Average speed | km/h | d / (t / 60) | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.