To average times in minutes and seconds, convert every time to seconds, add them up, divide by how many times you have, then convert the answer back to minutes and seconds.
To average times in minutes and seconds, convert every time to seconds, add them up, divide by how many times you have, then convert the answer back to minutes and seconds. For lap times of 4:32, 5:05, 4:48 and 5:15, the total is 1,180 seconds, the average is 295 seconds, and 295 seconds is 4:55.
The trap is treating times like ordinary decimals. Averaging 4.32 and 5.05 as numbers gives 4.685, which isn't a real time at all, because a minute has 60 seconds, not 100. That small slip catches out runners, swimmers, call-centre managers and students every day.
This guide shows the hand method, quick conversions, Excel and Google Sheets formulas and the special care you need when averaging paces and speeds. If you just want the answer, the free average time calculator does the sums for you.
In this guide:
The method works for any list of times, from 100-metre sprints to marathon finishes.
Here's the example from the top, written out:
| Lap | Time | Seconds |
|---|---|---|
| 1 | 4:32 | 4 × 60 + 32 = 272 |
| 2 | 5:05 | 5 × 60 + 5 = 305 |
| 3 | 4:48 | 4 × 60 + 48 = 288 |
| 4 | 5:15 | 5 × 60 + 15 = 315 |
| Total | 1,180 | |
| Average | 1,180 ÷ 4 = 295 seconds = 4:55 |
To convert 295 seconds back: 295 ÷ 60 = 4 remainder 55, so 4 minutes 55 seconds. If the average has a decimal, such as 295.5 seconds, write it as 4:55.5 or round to 4:56.
Our number system counts in tens. Time counts in sixties for seconds and minutes, and in twenty-fours for hours. Mixing the two leads to wrong answers.
Take two times: 1:50 and 2:10. As decimals, 1.50 and 2.10 average to 1.80, which you might read as "1 minute 80 seconds". That's nonsense. Converted properly, 110 seconds and 130 seconds average to 120 seconds, which is exactly 2:00.
The fix is always the same: get everything into one unit first. Seconds work for most tasks. For long durations, minutes or hours with decimals are fine, as long as you convert correctly.
Sometimes you'll see time written as decimal minutes, such as 5.75 minutes on a fitness app export or a timesheet. Converting is easy once you remember that 0.1 of a minute is 6 seconds.
| Decimal minutes | Minutes:seconds | Decimal hours | Hours:minutes |
|---|---|---|---|
| 0.25 | 0:15 | 0.25 | 0:15 |
| 0.5 | 0:30 | 0.5 | 0:30 |
| 0.75 | 0:45 | 0.75 | 0:45 |
| 1.2 | 1:12 | 1.2 | 1:12 |
| 2.4 | 2:24 | 2.4 | 2:24 |
| 5.75 | 5:45 | 7.5 | 7:30 |
| 8.33 | 8:20 (approx.) | 8.33 | 8:20 (approx.) |
The rule is identical for both columns: multiply the decimal part by 60. So 5.75 minutes is 5 minutes plus 0.75 × 60 = 45 seconds. Going the other way, divide the seconds by 60: 4:55 is 4 + 55 ÷ 60 = 4.917 minutes.
Timesheets use the hours version all the time. A shift of 7 hours 30 minutes is 7.5 hours, which matters when you multiply by an hourly rate.
For race results, film lengths or call durations, you'll often have hours in the mix. The method doesn't change. You just convert hours too.
Say three half-marathon finishes were 1:12:30, 0:58:45 and 1:05:10.
The total is 11,785 seconds. Divide by three to get 3,928.3 seconds. Convert back: 3,928.3 ÷ 3,600 = 1 hour with 328.3 seconds left, which is 5 minutes 28.3 seconds. The average is 1:05:28.
If you work with big totals, a quick converter helps. The days to hours converter handles larger units, such as turning total project time into hours for a report.
Excel stores times as fractions of a day, so 12 hours is 0.5 and one second is 1 ÷ 86,400. That makes averaging easy, as long as you enter and format the times correctly.
The square brackets matter. Plain mm:ss resets after 59 minutes, while [m]:ss shows the full count, such as 75:20. Microsoft's guide to adding and subtracting time in Excel explains these custom formats in more detail.
| Task | Formula |
|---|---|
| Average of times | =AVERAGE(B2:B10) |
| Build a time from minutes and seconds | =TIME(0,A2,B2) |
| Convert text like "4:32" to a time | =TIMEVALUE("0:"&A2) |
| Time to total seconds | =B2*86400 |
| Seconds back to a time | =A2/86400 (format as [m]:ss) |
| Round to nearest second | =MROUND(B2,"0:00:01") |
Google Sheets works almost the same way, with a couple of small differences.
Sheets also handles imported running or swimming logs well. Paste the times into one column, add a helper column that converts each to seconds with =B2*86400, and average that column. You'll see exactly what the formula is doing, which makes errors much easier to spot.
If you need a fastest or slowest time alongside the average, =MIN(B2:B10) and =MAX(B2:B10) work on durations too. Format them the same way as your average, and you've got a tidy summary row for any training log or timing sheet.
One tip for shared sheets: add a short note above the column saying "enter as h:mm:ss". It saves a lot of confused messages from teammates who type 4:32 and get 4 hours.
Averaging lap times is straightforward. Averaging paces or speeds needs more care, because a simple mean only works when each value covers the same distance.
Equal distances. Run 5 km at 5:00 per km and another 5 km at 6:00 per km, and your average pace is 5:30 per km. A plain average works here.
Unequal distances. Run 2 km at 5:00 and 8 km at 6:00, and the plain average still says 5:30. That's wrong. Your total time is 10 + 48 = 58 minutes over 10 km, so your real average pace is 5:48 per km.
Speeds over the same distance. Cycle 15 km out at 20 km/h and 15 km back at 30 km/h. The plain average says 25 km/h, but the trip took 45 + 30 = 75 minutes for 30 km, which is 24 km/h.
This is why running watches report average pace from your total time and distance rather than by averaging each kilometre split.
Durations and clock times look alike but behave differently. A duration measures how long something took. A clock time marks a moment in the day, and it wraps around at midnight.
That wrap causes trouble. Suppose you went to bed at 23:30 one night and 00:30 the next. The plain average of those values is 12:00, which suggests you slept at noon. The real answer is midnight.
The same idea works for wake-up times, delivery slots and shift start times that spread across midnight. In a spreadsheet, add 1 (a full day) to any time after midnight before averaging, then format the result as a clock time.
If your times all fall within the same half of the day, such as lunch breaks between 12:00 and 14:00, you can average them directly without any of this.
Average time calculations crop up in plenty of everyday jobs:
For call centres, look at the median as well as the mean. A few very long calls can drag the average up, while the median shows what a typical customer experiences.
Averages also help you track progress. If your average 1 km split drops from 5:40 to 5:25 over a month of training, that's a clear, honest sign of improvement.
These slip-ups account for most wrong averages:
Double-check your result with a quick sanity test. The average should always sit between the fastest and slowest times in your list. If it doesn't, something went wrong in the conversion.
Convert each time to seconds, add them, divide by the number of times, then convert back. Divide by 60 for minutes and use the remainder as seconds.
4:45. Convert to 270 and 300 seconds, average them to get 285 seconds, then convert back to 4 minutes 45 seconds.
Use the mean for consistent data such as training laps. Use the median when a few extreme values, like very long calls, would distort the picture.
Multiply the decimal part by 60. For example, 3.4 minutes is 3 minutes plus 0.4 × 60 = 24 seconds, so 3:24.
You probably typed times like 4:32, which Excel reads as hours and minutes. Enter 0:04:32 and format the result as [m]:ss.
Use =AVERAGE() and format the result with [h]:mm:ss or [m]:ss. The square brackets stop the display wrapping at 60.
Divide total time by total distance. A 58-minute run over 10 km gives an average pace of 5:48 per km.
Only if each speed covers the same amount of time. Otherwise, divide total distance by total time to get the true average speed.
Last checked: 18 October 2026. Rates, rules and app settings can change, so confirm anything important with the official source linked above.
Stacked discounts multiply rather than add. To find the final price, multiply the original price by (1 − first discount) and then by (1 − second discount). So 20% off followed by an extra 10% off gives 0.8 × 0.9 = 0.72 of the price, which is 28% off, not 30%.
The fastest fair way to split a class into random groups is to shuffle the full list of names and deal them out one by one into the number of groups you need, like dealing cards.
If you work irregular hours or only part of the year in the UK, you build up paid holiday at 12.07% of the hours you work in each pay period. Your employer can either pay you for that holiday when you take it, or add 12.07% to every payslip as "rolled-up" holiday pay.