Charts and Custom Number Formats
- Average speed (km/h)
- km/h
- Result
- Time (minutes)
- 50 min
- You entered
- Distance (km)
- 10 km
- You entered
Charts and custom number formats let you control exactly how numbers appear on a chart axis, data label, or tooltip in spreadsheet software like Excel and Google Sheets. You enter a format code such as #,##0.0 or 0.0E+00 in the axis or label format box, and the chart displays your numbers in that style without changing the underlying values. This article explains how chart number formatting works, how to write your own format codes, and how to avoid the most common pitfalls.
Formula
Average pace (min/km) = Total time (minutes) ÷ Distance (km).
Average speed (km/h) = Distance (km) ÷ (Total time (minutes) ÷ 60).
Variables:
• t = total time in minutes
• d = distance in kilometers
• pace = minutes per kilometer (a lower number is faster)
• speed = kilometers per hour (a higher number is faster)
Both formulas use the same two inputs, but they express the relationship in different units. Pace tells you how long one kilometer takes; speed tells you how many kilometers you cover in one hour.
Worked Example
Using the default values of t = 50 minutes and d = 10 km:
- Pace = 50 ÷ 10 = 5.0 min/km
- Speed = 10 ÷ (50 ÷ 60) = 10 ÷ 0.8333… = 12.0 km/h
The calculator shows pace as 5.00 min/km and speed as 12.00 km/h with two decimal places. You can change the decimal places in the output settings if you want fewer or more digits.
When to Use Pace vs. Speed
Runners and walkers typically use pace (min/km or min/mile) because it directly answers “how long will this take?” Cyclists and drivers usually use speed (km/h or mph) because it matches road signs and vehicle speedometers. Both are valid, but mixing them can confuse an audience. If you are creating a chart for a running app, use pace; for a car trip calculator, use speed.
How to Read the Result
A pace of 5.00 min/km means you run one kilometer every five minutes. A speed of 12.00 km/h means you cover twelve kilometers in one hour. Notice that a lower pace is faster, while a higher speed is faster. When you compare two runs, a smaller pace number is better; when you compare two drives, a larger speed number is better.
Common Mistakes
- Mixing units: If your time is in minutes and your distance is in miles, the pace is min/mile, not min/km. Convert first.
- Forgetting to convert time: If you enter time in hours and minutes (like 1:30), convert to minutes (90) before dividing.
- Rounding too early: Round only the final answer, not intermediate steps. For example, 50 ÷ 10 = 5.0 exactly, but if you had 50 ÷ 9 = 5.555…, rounding to 5.6 before computing speed would give 10.7 instead of 10.8.
- Confusing pace and speed: They are reciprocals (with unit conversions). A pace of 5 min/km equals a speed of 12 km/h, not 5 km/h.
Limitations of the Formula
These formulas assume constant speed with no stops, hills, or changes in effort. Real-world runs and drives include traffic lights, elevation, and fatigue, so the calculated pace and speed are averages, not instantaneous values. The formula also ignores units like seconds – if you want seconds, you need to convert them to minutes first (e.g., 5 min 30 sec = 5.5 min).
Frequently Asked Questions
How do I convert pace to speed?
Speed (km/h) = 60 ÷ pace (min/km). For example, a 5 min/km pace gives 60 ÷ 5 = 12 km/h. To convert speed to pace, use pace = 60 ÷ speed.
What if I run a marathon in 4 hours?
First convert hours to minutes: 4 hours = 240 minutes. Then divide by the marathon distance (42.195 km). Pace = 240 ÷ 42.195 ≈ 5.69 min/km. Speed = 42.195 ÷ (240 ÷ 60) = 42.195 ÷ 4 = 10.55 km/h.
Is a lower pace always better?
Yes, for a fixed distance, a lower pace means less time. But pace alone doesn’t tell you about effort – a 5 min/km pace on flat ground is different from the same pace uphill.
What is the difference between min/km and min/mile?
Min/km uses kilometers; min/mile uses miles. To convert min/km to min/mile, multiply by 1.60934. For example, 5 min/km ≈ 8.05 min/mile. To convert the other way, divide by 1.60934.
Can I use this for walking or cycling?
Yes, the formulas work for any activity where you know time and distance. For cycling, speed is more common, but pace is still valid if you prefer it.
Related
Formula used
in t | Time (minutes) | min | 50 | 0 in d | Distance (km) | km | 10 | 0 out pace | Average pace (min/km) | min/km | t / d | 2 out speed | Average speed (km/h) | 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.