Choose All Cells: Excel Selection Explained
- Average speed
- km/h
- Result
- Finish time
- 50 min
- You entered
- Distance
- 10 km
- You entered
This guide explains what it means to “choose all cells” in a spreadsheet, covering the essential shortcuts and methods for selecting an entire worksheet, a contiguous range, or non-adjacent cells. You will learn the fastest ways to do this in Microsoft Excel and Google Sheets, along with common pitfalls and practical tips for working with large datasets.
Formula
The calculator above is a pace and speed converter. It takes a finish time (in minutes) and a distance (in kilometers) and computes the average pace (minutes per kilometer) and the average speed (kilometers per hour). The formulas are:
Pace (min/km) = Finish time (min) ÷ Distance (km)
Speed (km/h) = Distance (km) ÷ (Finish time (min) ÷ 60)
Where:
- Finish time (t) is the total minutes taken to cover the distance. If you have hours and minutes, convert to minutes first (e.g., 1:30:00 = 90 minutes).
- Distance (d) is the length of the run or ride in kilometers. For miles, multiply by 1.60934 to get kilometers.
- Pace is the result in minutes per kilometer, shown to two decimal places.
- Speed is the result in kilometers per hour, shown to two decimal places.
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
The calculator shows an average pace of 5.00 min/km and an average speed of 12.00 km/h for these inputs.
When to Use This Calculator
Use this tool whenever you have a finish time and a distance and want to know your average pace or speed. It is common for runners, cyclists, and walkers who track their workouts. For example, if you ran 5 km in 30 minutes, your pace is 6:00 min/km (30 ÷ 5) and your speed is 10 km/h (5 ÷ (30/60)). The calculator gives you both numbers instantly, saving you from manual math.
It also works for any distance-based activity. If you swam 1.5 km in 45 minutes, your pace is 30 min/km and speed is 2 km/h. The same formulas apply regardless of the sport.
How to Read the Results
The pace result tells you how many minutes it takes to cover one kilometer. A lower pace number means you are moving faster. For example, a pace of 4:30 min/km is faster than 6:00 min/km. The speed result tells you how many kilometers you cover in one hour. A higher speed means you are moving faster.
Note that pace and speed are inversely related: when pace goes down, speed goes up. The calculator shows both so you can use whichever metric you prefer. Most runners think in pace (min/km), while cyclists often think in speed (km/h).
Common Mistakes and Unit Mix-Ups
The most frequent error is mixing units. If you enter a distance in miles but the calculator expects kilometers, your pace and speed will be wrong. Always convert miles to kilometers first (1 mile = 1.60934 km). Similarly, if your finish time is in hours and minutes, you must convert to total minutes. For example, 1 hour 15 minutes is 75 minutes, not 1.15.
Another common mistake is rounding too early. If you round your pace to a whole number before using it in another calculation, you may introduce errors. The calculator rounds only the final output to two decimal places, which is accurate enough for most training purposes.
Limitations of the Formula
The formula assumes a constant pace throughout the entire distance. In reality, your pace may vary due to hills, wind, or fatigue. The result is an average, not a real-time measurement. For interval training or uneven terrain, the average pace may not reflect the effort at any given moment.
The calculator also ignores rest stops or pauses. If you stop for water or traffic lights, the total time includes those stops, so the average pace will be slower than your actual moving pace. To track moving pace, you would need a GPS watch or app that records time in motion.
Frequently Asked Questions
How do I convert my pace from min/km to min/mile?
Multiply the pace in min/km by 1.60934 to get min/mile. For example, a 5:00 min/km pace is about 8:03 min/mile. Conversely, divide min/mile by 1.60934 to get min/km.
What is a good running pace for a beginner?
There is no single answer because it depends on age, fitness, and gender. A common conversational pace for a beginner might be around 7:00 to 9:00 min/km (11 to 14 km/h). The best way to gauge is to run at a pace where you can talk without gasping.
Can I use this calculator for walking?
Yes, the formulas work for any activity that involves covering a distance over time. Walking pace is typically slower, often 10 to 15 min/km, but the calculator handles any values you enter.
How do I convert hours and minutes to minutes for the finish time?
Multiply the hours by 60 and add the minutes. For example, 1 hour 20 minutes is (1 × 60) + 20 = 80 minutes. If you have seconds, divide by 60 and add that to the minutes (e.g., 45 seconds = 0.75 minutes).
Why does the calculator show pace in two decimals?
Two decimals give enough precision for training purposes. A pace of 5.34 min/km is about 5 minutes and 20 seconds per kilometer. If you need seconds, multiply the decimal part by 60 (0.34 × 60 = 20.4 seconds).
What if I know my speed but not my pace?
You can use the same relationship: pace = 60 ÷ speed. For example, if you are moving at 12 km/h, your pace is 60 ÷ 12 = 5.00 min/km. The calculator gives you both, but you can also compute one from the other manually.
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.