ThisCalculator

Everyday

Custom Number Formats in Excel: A Complete 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

Custom number formats in Excel let you control exactly how numbers appear in cells without changing the underlying value. You create them by entering a format code into the Format Cells dialog box, and they can add text, change colors, hide zeros, or display dates and times in any way you need.

Formula

The formula for average pace is:

pace = finish time (in minutes) / distance (in km)

Where:

  • finish time is the total time taken in minutes.
  • distance is the distance covered in kilometers.
  • pace is the result in minutes per kilometer.

For speed in km/h:

speed = distance (km) / (finish time (min) / 60)

This converts the time to hours, then divides distance by that value.

Worked Example

Using the default values from the calculator: 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

The calculator shows 5.00 min/km and 12.00 km/h, matching these results.

When to Use This Calculator

This is useful for runners, cyclists, and walkers who want to know their average pace or speed over a known distance. Coaches use it to plan training paces, and event organizers use it to estimate finish times. It works for any distance unit as long as you convert everything consistently—if you enter miles, the pace will be in minutes per mile, and speed in miles per hour.

How to Read the Results

Pace is the time it takes to cover one unit of distance. A lower pace number means faster. Speed is the distance covered per hour. A higher speed number means faster. For example, a pace of 5 min/km means you run each kilometer in 5 minutes, which is equivalent to 12 km/h. If you are comparing two runs, the one with the lower pace (or higher speed) is the faster one.

Common Mistakes and Unit Mix-ups

The most common error is mixing units. If you enter distance in miles but think in kilometers, your pace will be in minutes per mile, not per kilometer. Always check which unit the distance is in. Another mistake is entering time in hours and minutes instead of total minutes. For example, 1 hour 30 minutes must be entered as 90 minutes, not 1.30. Also, rounding too early can skew results—keep at least two decimal places until the final step.

Limitations of the Formula

This formula assumes a constant speed throughout the entire distance. In real life, pace varies due to terrain, wind, and fatigue. It also does not account for stops or pauses. For interval training or hilly routes, the average pace may not reflect the effort level. The result is a simple arithmetic average, not a weighted or adjusted value.

Frequently Asked Questions

Can I use this for marathon training?

Yes, but remember the distance must be the full race distance, such as 42.195 km for a marathon. Enter your target finish time in minutes, and the calculator will give you the average pace you need to maintain.

What if I run on a treadmill?

Treadmill distances are usually shown in miles or kilometers. Enter the distance shown on the treadmill and the time you ran. The result will be your average pace, but treadmills often have a slight calibration error, so the actual outdoor pace may differ.

How do I convert pace to speed?

Speed = 60 / pace (if pace is in minutes per km). For example, a pace of 5 min/km gives 60 / 5 = 12 km/h. The calculator does this automatically for you.

Is walking pace calculated the same way?

Yes, the formula is identical. Walking pace is typically slower, so the minutes per km will be higher. For example, a 20 min/km pace is a gentle stroll, while 8 min/km is brisk walking.

Why does the calculator show two decimal places?

Two decimal places give enough precision for most pacing needs without being overly cluttered. For race planning, you might want more precision, but for everyday training, two decimals is standard.

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.