Sort by Custom List: How It Works

Sorting by a custom list lets you arrange rows or items in an order you define, rather than alphabetically, numerically, or by date. You provide the sequence (for example, High, Medium, Low), and the software ranks your data according to that sequence. This is useful whenever the natural sort order doesn’t match the order that matters to you, such as priority levels, stages in a workflow, or days of the week starting on Monday.

Formula

This calculator works out your average pace and speed for a run, ride, or walk. You enter the total time in minutes and the distance in kilometers. The calculator returns your average pace in minutes per kilometer and your average speed in kilometers per hour.

The formulas are:

• Pace = Total time (minutes) ÷ Distance (km)
• Speed = Distance (km) ÷ (Total time (minutes) ÷ 60)

Where:

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

Worked Example

Using the default values: t = 50 minutes, d = 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 a pace of 5.00 min/km and a speed of 12.00 km/h.

When to Use This Calculator

Use this tool when you want to know how fast you are moving on average over a known distance. Runners often use pace to plan training efforts, while cyclists and walkers may prefer speed. You can also use it to compare two workouts: enter the time and distance for each and see which had a faster pace.

The result is an average, so it does not tell you how your speed varied during the activity. If you run hills or stop at traffic lights, your instantaneous speed will go up and down, but the average smooths all that out.

How to Read the Result

A lower pace (minutes per kilometer) means faster. A pace of 4:30 per km is quicker than 5:00 per km. Speed works the opposite way: a higher number in km/h is faster. The two numbers are simply two ways of expressing the same performance.

If you are used to miles, convert the distance to kilometers first (1 mile = 1.60934 km) or convert the pace to minutes per mile by multiplying the min/km value by 1.60934.

Common Mistakes

• Mixing units: Entering distance in miles but expecting km/h speed. Always convert to the same unit system.
• Using seconds instead of minutes: The calculator expects total time in minutes. If you have 1 hour 10 minutes, enter 70, not 1.10.
• Rounding too early: If you round the pace to 5.0 and then multiply back, you may get a slightly different speed. Keep full precision until the end.

Limits of the Formula

This is a simple average, so it does not account for elevation gain, terrain, wind, or rest breaks. It is best used for steady, continuous efforts on flat ground. For interval training or hilly routes, the average pace will be less representative of your true effort.

The formula also assumes you move at a constant speed, which is rarely true. Still, for most training logs and race planning, the average pace is a useful, standard metric.

Frequently Asked Questions

Can I use this for walking? Yes, the same formula works for walking. Enter your total walking time and distance, and you will get your average walking pace and speed.

What if I run on a treadmill? Treadmills often show speed in km/h or mph. If you know the speed and the time, you can calculate distance as speed × time, then use this calculator to get pace. Or just enter the time and the distance the treadmill reports.

How do I convert min/km to min/mile? Multiply the pace in min/km by 1.60934. For example, 5:00 min/km × 1.60934 = 8:02 min/mile.

Is a faster pace always better? Not necessarily. For long endurance events, a slower pace that you can sustain is better than a fast pace that leads to early fatigue. Use pace to plan effort relative to your goal distance.

Why does the calculator show speed in km/h and not mph? The calculator uses kilometers as the default unit. You can convert the result to mph by dividing the km/h value by 1.60934, or convert the distance to miles before entering it.

Related

• Dreamlight Valley Parks Fest Quests & Green Button Rewards
• Acer Collection S: Decline or Uninstall?
• C Drive Space Error: Fix ‘Not Enough Space to Extract

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