ThisCalculator

Everyday

Enter Same Data in Multiple Cells: Quick Guide

Updated · Standard formula, shown below

Average pace 5.00 min/km
Average speed
12.00 km/h
Result
Finish time
50 min
You entered
Distance
10 km
You entered

Yes, you can enter the same data in multiple cells at once in Excel, Google Sheets, and most other spreadsheet programs. The fastest way is to select the cells, type the value, and press Ctrl+Enter (Windows) or Cmd+Enter (Mac) instead of just Enter. This guide covers that method and several others, along with when to use each.

Formula

The calculator above works out your average pace and speed for a run, ride, or walk. You enter the total time taken and the distance covered. The formulas are:

  • Pace (min/km) = Total time (min) ÷ Distance (km)
  • Speed (km/h) = Distance (km) ÷ (Total time (min) ÷ 60)

Where:

  • t = finish time in minutes (e.g., 50)
  • d = distance in kilometers (e.g., 10)

Pace is the number of minutes it takes to cover one kilometer. Speed is the number of kilometers you cover in one hour. They are two ways of expressing the same effort: a 50-minute 10 km run is a 5:00 min/km pace, which equals 12 km/h.

Worked Example

Using the default values from the calculator: time = 50 minutes, distance = 10 km.

  1. Pace = 50 ÷ 10 = 5.0 min/km (displayed as 5.00).
  2. Speed = 10 ÷ (50 ÷ 60) = 10 ÷ 0.8333 = 12.0 km/h (displayed as 12.00).

So a 50-minute 10 km run gives an average pace of 5 minutes per kilometer and an average speed of 12 kilometers per hour.

When to Use Pace vs. Speed

Runners and walkers usually think in pace (minutes per kilometer or mile) because it directly tells you how fast you are moving relative to distance. Cyclists and drivers usually think in speed (km/h or mph) because that is what their speedometer shows. Both are mathematically equivalent, so choose the one that matches your sport or your device.

For example, if you are training for a 5 km race and want to finish in 25 minutes, your target pace is 5:00 min/km. If you are cycling and want to cover 30 km in one hour, your target speed is 30 km/h. The calculator gives you both so you can switch between them without redoing the math.

How to Read the Result

The first output is your average pace in minutes per kilometer, shown with two decimal places. A pace of 5.00 means 5 minutes exactly. A pace of 5.30 means 5 minutes and 18 seconds (0.30 × 60 = 18 seconds). The second output is your average speed in km/h, which is a straightforward number.

If you use miles, convert the distance to kilometers first (1 mile = 1.60934 km) or use a separate pace calculator that works in miles. The same formulas apply, but the units change.

Common Mistakes

The most common error is mixing units. If you enter a distance in miles but the formula expects kilometers, your pace will be wrong. Always check that your distance unit matches the pace unit you want.

Another mistake is using elapsed time instead of moving time. If you pause your watch at traffic lights, the elapsed time includes those stops, which makes your average pace slower than your actual running pace. Decide which you want to measure and be consistent.

Rounding too early can also cause small errors. For example, if you round 50 ÷ 10 to 5.0 and then try to compute speed from that rounded pace, you might get 12.0 km/h instead of the exact 12.0. In this case it is fine, but for other numbers the difference can matter. Use the full precision until the final step.

Limitations of the Formula

This formula assumes a constant speed over the whole distance. In reality, your pace varies with hills, wind, and fatigue. The result is an average, not a description of your splits. If you need to plan pacing for a race with elevation gain, you would need a more complex model that includes gradient and energy expenditure.

The formula also ignores rest breaks. If you stop for water, the total time includes that stop, so the pace will be slower than your actual moving pace. For training purposes, many athletes use moving time instead of elapsed time.

Frequently Asked Questions

How do I convert pace to speed? Divide 60 by the pace in minutes per kilometer. For example, a 5:00 min/km pace gives 60 ÷ 5 = 12 km/h. For pace in minutes per mile, divide 60 by the pace to get mph.

What is a good running pace for a beginner? A common beginner pace is around 6:30 to 7:30 min/km (about 9.2 to 8.0 km/h). This varies widely with age, fitness, and terrain. The calculator just tells you the numbers; it does not judge what is good.

Should I use a pace calculator for walking? Yes, the same formula works for walking. A typical walking pace is 12 to 15 minutes per kilometer (4 to 5 km/h). The calculator is unit-agnostic, so it works for any distance and time.

How do I calculate pace for a marathon? Enter the total time you want (e.g., 3 hours = 180 minutes) and the marathon distance (42.195 km). The calculator will give you the average pace per kilometer. For a 3:30 marathon, that is 180 ÷ 42.195 ≈ 4.27 min/km, or about 4:16 per km.

Why does my GPS watch show a different pace? GPS watches calculate pace based on GPS distance, which can be slightly longer than the official course distance due to turns and measurement error. They also use moving time by default, not elapsed time. So your watch pace may be faster than your chip time pace.

Can I use this for cycling? Yes, cyclists can use the same speed formula. Just enter the time and distance. For cycling, speed in km/h is more common than pace, so look at the second output.

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.