# How to calculate running pace per mile in Excel

Divide the time by the distance and format as mm:ss: `=C2/B2`.

**Excel:** `=C2/B2` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D |
| --- | --- | --- | --- |
| Run | Distance (mi) | Time | Pace (per mile) |
| 5K | 3.1 | 0.019375 |  |
| 10K | 6.2 | 0.040740740740740744 |  |
| Half marathon | 13.1 | 0.08229166666666667 |  |
| Tempo run | 5 | 0.029513888888888888 |  |
| Marathon | 26.2 | 0.17505787037037038 |  |

Formula in D2, filled to D6: `=C2/B2`

Result: 09:00; 09:28; 09:03; 08:30; 09:37

## How it works

A time is a fraction of a day, and dividing it by the distance gives the time per mile, still a fraction of a day. Formatted as mm:ss, it reads as a pace: 27:54 over 3.1 miles is 9:00 per mile.

## Other ways

- `=C2*1440/B2`: Pace in decimal minutes per mile, like 9.0. (Decimal minutes.)
- `=TEXT(C2/B2,"m:ss")&" /mi"`: A label like 9:00 /mi. (Text label.)

## Common mistakes

- Enter run times with the hours: 0:27:54. Typed as 27:54, the time is read as 27 hours 54 minutes.
- The mm:ss format wraps at 60 minutes, which is fine for paces; use h:mm:ss for the run times.

## Questions

**How do I calculate pace per kilometer?**

Divide by kilometers, or by miles × 1.609: `=C2/(B2*1.609)`.

**How do I calculate speed in mph?**

`=B2/(C2*24)`: distance divided by hours.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/running-pace-per-mile