keepcalculator

06 Numbers and Powers

Row Is Blank? Meaning & Fixes

Card No. 06·51345 · 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
You enter
Finish time, Distance
You get
Average pace, Average speed
Rounding
2 dp

“Row is blank” is a common error message in spreadsheet software like Microsoft Excel and Google Sheets, indicating that a formula is referencing an empty cell or that a data range includes blank rows. This article explains what causes this error, how to fix it, and how to prevent it, with practical steps for both Excel and Google Sheets.

Formula

The calculator above works out your average pace and speed for a run, cycle, or walk. You enter your finish time in minutes and the distance in kilometers, and it returns your average pace (minutes per kilometer) and 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:

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

Pace is the time it takes to cover one kilometer; speed is how many kilometers you cover in one hour. They are reciprocals when units are consistent.

Worked Example

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

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

So a 50-minute 10K gives an average pace of 5:00 per kilometer and an average speed of 12 km/h. The calculator shows the same results.

When to Use This Calculator

Use this tool for any activity where you know the total time and distance: running, cycling, swimming, or walking. It is especially useful for setting training paces, planning race splits, or comparing efforts across different distances. For example, if you run 5 km in 30 minutes, your pace is 6:00/km and your speed is 10 km/h.

How to Read the Results

The pace result is shown in minutes per kilometer (or per mile if you convert). A lower pace means faster. The speed result is in kilometers per hour (or miles per hour). For most runners, pace is more intuitive because it directly tells you how long each kilometer takes. Speed is more common in cycling or driving contexts.

Common Mistakes

  • Mixing units: If you enter distance in miles but time in minutes, the pace is in minutes per mile, not per kilometer. Convert miles to kilometers (1 mile = 1.60934 km) or use consistent units.
  • Using seconds instead of minutes: The calculator expects minutes. If you have 1 hour 30 minutes, enter 90, not 1.30.
  • Rounding too early: Round only the final answer, not intermediate steps, to avoid small errors.

Limitations of the Formula

This is a simple average calculation. It does not account for elevation gain, terrain, stops, or variations in pace. Your actual instantaneous pace will vary, but the average is a useful summary. The formula also assumes a constant speed, which is rarely true, but the average is still valid for planning.

Frequently Asked Questions

How do I convert pace to speed and vice versa?

Pace (min/km) and speed (km/h) are reciprocals. To convert pace to speed, divide 60 by the pace. For example, 5 min/km → 60 ÷ 5 = 12 km/h. To convert speed to pace, divide 60 by the speed: 12 km/h → 60 ÷ 12 = 5 min/km.

What is a good running pace for a beginner?

A typical beginner might run at 7–10 min/km (6–8.5 km/h), but it varies greatly with age, fitness, and terrain. Focus on effort rather than a specific number; a conversational pace is a common guideline.

Can I use this for walking?

Yes. Walking pace is usually 10–15 min/km (4–6 km/h). Enter your time and distance, and the calculator works the same way.

How do I calculate pace for a marathon?

A marathon is 42.195 km. If you want to finish in 4 hours (240 minutes), enter 240 and 42.195. The pace will be about 5:41 per km.

What if I run on a treadmill?

Treadmill speed is often shown in km/h. You can use the speed output directly. To find pace, divide 60 by the treadmill speed.

Related

Formula used
in t | Finish time | min | 50 | 0
in d | Distance | km | 10 | 0 | 100000
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.

More cards in this drawer

The whole Numbers and Powers drawer →