Drag Formula Without Changing Google Sheets? 6 Ways

You can drag a formula down a column in Google Sheets without permanently changing the cell references by using the ARRAYFORMULA function, or by converting the formula to an absolute reference with dollar signs ($). The quickest method is to wrap your existing formula in ARRAYFORMULA and apply it to the entire column, which lets you drag (or not drag) without altering the formula. Below are six reliable methods, from simplest to most advanced, so you can choose what fits your data.

Formula

The core formula for average pace is:

pace = total time / distance

Where:

• pace = time per unit distance (min/km)
• total time = minutes taken to cover the distance
• distance = length of the run or walk (km)

For speed (km/h): speed = distance / (time in hours)

Since time is in minutes, divide by 60 to convert to hours.

Worked Example

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

1. Calculate pace: 50 min ÷ 10 km = 5.0 min/km
2. Calculate speed: 10 km ÷ (50/60) hours = 10 ÷ 0.8333 = 12.0 km/h

The calculator shows pace = 5.00 min/km and speed = 12.00 km/h.

When to Use This Formula

This formula is for any activity where you track time and distance: running, cycling, walking, or swimming. It gives you a quick, objective measure of your performance. Runners often use pace to set training zones, while cyclists prefer speed. Both are derived from the same two inputs, so you only need to measure time and distance once.

How to Read the Result

A lower pace (e.g., 4:30 min/km) means faster. A higher speed (e.g., 15 km/h) also means faster. The two metrics are inversely related: if pace decreases, speed increases. Use pace for short intervals and speed for steady efforts. Remember that pace is usually expressed in minutes per kilometer, but some regions use minutes per mile. The calculator uses km, so if you work in miles, multiply the distance by 1.60934 to convert to km.

Common Mistakes and Unit Mix-Ups

• Mixing units: Entering distance in miles but time in minutes gives a wrong pace. Always convert to the same unit system.
• Forgetting to convert hours: Speed requires time in hours, not minutes. Divide minutes by 60.
• Rounding too early: Keep at least two decimal places during calculation to avoid errors.
• Using total time instead of moving time: If you pause your watch, use moving time for accuracy.

Limitations of the Formula

This formula assumes constant speed. Real-world runs have hills, stops, and wind, so pace varies. It also ignores elevation gain, which can make a 6:00 min/km pace feel harder than a 5:00 pace on flat ground. For hilly routes, consider using a heart rate monitor or power meter for more context. The formula is a simple average, not a predictor of race performance.

Frequently Asked Questions

How do I convert pace from min/km to min/mile?

Multiply the pace in min/km by 1.60934. For example, 5 min/km × 1.60934 = 8.05 min/mile. Conversely, divide min/mile by 1.60934 to get min/km.

Is a lower pace always better?

Yes, lower pace means you are covering each kilometer faster. However, “better� depends on your goal. For endurance training, you might deliberately run at a slower pace to build aerobic base.

What if I run on a treadmill and it shows speed in mph?

Convert mph to km/h by multiplying by 1.60934. Then use that speed in the calculator. For example, 6 mph × 1.60934 = 9.66 km/h.

Can I use this formula for walking?

Yes, it works for any activity where you track time and distance. Walking pace is typically higher (slower) than running, but the math is the same.

Why does my GPS watch show a different pace than this calculator?

GPS watches often use real-time pace, which fluctuates with terrain and signal. This calculator gives an average over the whole activity. Also, watches may calculate pace based on GPS distance, which can have a small error.

Should I use moving time or elapsed time?

For a true average pace, use moving time (time when you are actually moving). Elapsed time includes stops for water or traffic lights, which makes your pace look slower than it really was.

Related

• Clean MacBook Screen, Keyboard & Trackpad Safely
• Free Galaxy Storage Without Removing Apps: What Works?
• DNA Origami Flask: How Folded Strands Form a Lab

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