Instant online tool
Average duration and clock time in one paste, with midnight-safe math.
Durations? Paste lap, commute, or task times. Times of day? Switch to Clock Time.
One value per line. Accepts 1:30:45, 45:30, 90s, 1h 23m, 1.5h, and 11:45 PM. In weighted mode, add a comma or tab followed by the weight.
Share creates a link that restores this exact input, mode, and options.
Load an example
What is it?
An average time calculator finds the mean of a set of durations or clock times. For durations, convert each value to seconds, add them together, and divide by the count. For clock times, use circular averaging so values such as 23:50 and 00:10 average close to 00:00 instead of 12:00.
| Input type | Correct method |
|---|---|
| Duration | Sum all elapsed times, then divide by count. |
| Clock time | Average the angles on a 24-hour circle. |
Why midnight changes the answer
Most average time calculators treat every value as a duration. That works for lap times, but it can give a wrong answer when you average clock times around midnight.
Add all elapsed times together, then divide by the number of values. Use it for race laps, commute time, workouts, tasks, and customer handling time.
1:30 + 1:25 + 1:35 = 1:30
Use circular averaging to find the middle point of several clock times, even when they cross midnight. Use it for bedtimes, arrivals, and shift times.
23:50 + 00:10 = 00:00
Most time-average tools only handle elapsed durations. This page separates durations from times of day, shows supporting statistics, and keeps everything in the browser.
| What you need | Typical time-average tool | This calculator |
|---|---|---|
| Duration or clock time | Durations only, so midnight is often wrong. | Both modes, with circular averaging for clock times. |
| Result context | Usually one average, sometimes total and count. | Average, total, count, min, max, median, and range or spread. |
| Advanced averages | Rarely available. | Weighted and running averages with examples and charts. |
| Bulk input | Often split into hour, minute, and second fields. | One textarea for mixed formats, paste, and CSV import. |
| Privacy | May require sign-up, ads, or server-side processing. | Free, private, no ads, and no data leaves the browser. |
For durations, convert everything to seconds, sum the values, and divide by the count. For clock times, map each value to an angle on a 24-hour circle and average the angles.
Duration average
Average = Total time / Number of values
Clock time average
Convert each time to an angle, average the sine and cosine values, then convert the resulting angle back to a time.
Why midnight changes the answer
Plain arithmetic on 23:50 and 00:10 produces 12:00. Circular averaging correctly gives 00:00 because both values sit close together on the 24-hour clock.
The same principle applies to both modes: convert every value to a common unit first. The difference is what happens after conversion. Duration data is measured on a straight line, while clock time is measured on a circle that wraps every 24 hours.
Start with a small running log. Each lap is already written as minutes and seconds, but the calculation is easiest after converting everything to seconds.
1:32.40 1:31.20 1:33.10 1:30.85
| Lap | Seconds |
|---|---|
| 1:32.40 | 92.40 |
| 1:31.20 | 91.20 |
| 1:33.10 | 93.10 |
| 1:30.85 | 90.85 |
Two bedtimes sit close together on the clock even though their hour numbers look far apart.
23:50 00:10
| Time | Angle | Interpretation |
|---|---|---|
| 23:50 | 357.5° | 10 minutes before midnight |
| 00:10 | 2.5° | 10 minutes after midnight |
Elapsed time behaves like any other measurement. You can add the seconds without changing their meaning, then divide by the number of observations.
Average duration = (t₁ + t₂ + ... + tₙ) / n
A clock has no natural start point. Converting to angles and averaging sine and cosine preserves the fact that 23:50 and 00:10 are only 20 minutes apart.
Mean angle = atan2(Σ sin θ, Σ cos θ)
The workflow is designed to be faster than a spreadsheet: paste, choose a mode, read the summary, and export.
01
Select duration average for elapsed time or clock time average for times of day.
02
Enter one time value per line, paste from a spreadsheet, or import a CSV file.
03
Review the average, total or spread, count, min, max, median, and range. In duration mode, enable Average pace to show the pace per km or per mile.
04
Copy the summary, download CSV, or copy a shareable link with your current input.
The input parser is designed for real-world records. You can paste a column from Excel, a run log, a sleep tracker, or a call report without splitting each value into separate fields.
| Format | Example |
|---|---|
| HH:MM:SS | 1:30:45 |
| MM:SS | 45:30 |
| Seconds | 90s or 90 |
| Decimal time | 1.5h or 45.5m |
| Compound units | 1h 23m 45s |
| Milliseconds | 1:30.450 or 90.25s |
| 24-hour clock | 23:50 |
| 12-hour clock | 11:45 PM |
| Weighted syntax | 4m 20s,3 or 4m 20s<TAB>3 |
You can paste records from a spreadsheet, a run log, a call report, or a sleep tracker. The input accepts common time formats without making you split every value into separate boxes.
Compare average lap speed across a session and see the spread between your fastest and slowest effort.
Average a week of commutes to understand your realistic daily travel time.
Track rest and work intervals, then find a target pace from the median rather than one outlier.
Calculate average handling time with weighted values when some calls represent larger groups.
Find your average bedtime without the midnight problem distorting the result.
Turn scattered time logs into a clear average, total, and range for planning.
The same calculator, applied to three common jobs: a weekly call report, a training session, and a sleep log.
A plain average treats a 3-call group the same as a 120-call group. Weighted duration keeps the report honest.
Example
3 calls × 20 min + 120 calls × 6 min → weighted 6:20, not 13:00
Interval splits jump around. The median shows typical effort; the mean is pulled by one bad rep.
Example
5 × 1 km: 3:58, 4:02, 4:11, 4:03, 5:20 → median 4:03 vs mean 4:19
Bedtimes around midnight break a normal average: 23:50 and 00:10 average to 12:00 instead of 00:00.
Example
23:50, 00:10, 00:05 → circular mean 00:02 (plain average: 08:02)
The same calculation appears in different jobs under different names. Choose the mode based on whether your values are elapsed time or points in the day.
| Role or field | Typical data | Best mode | Why supporting stats help |
|---|---|---|---|
| Runner or coach | Lap splits, repeats, race segments | Duration | Median shows typical effort; range reveals consistency. |
| Commuter | Daily travel time over one or two weeks | Duration | Median is a better estimate when one day is unusually bad. |
| Call center analyst | Handling time by call group or agent | Weighted duration | Weights keep a 20-call group from counting the same as one call. |
| Sleep tracker | Bedtimes, wake times, or both | Clock time | Circular mean keeps 23:50 and 00:10 close to midnight. |
| Operations manager | Task durations, cycle time, wait time | Duration | Total and count turn an average into a capacity estimate. |
| Data or support analyst | Response times, resolution times | Duration | Compare median with mean to detect slow outliers. |
| Shift scheduler | Clock-in or arrival times | Clock time | Circular spread shows whether arrival times are tightly grouped. |
Three realistic walkthroughs showing the input, the steps, and what the result means. Click the link in each example to load the values into the calculator and follow along.
Runner or coach
Paste these values
1:32.40Watch out: average pace and average speed are not the same. To get average speed, use total distance divided by total time (the harmonic mean of the speeds). Averaging km/h values directly overweights slow laps.
Call center analyst
Paste these values
4m 20s,3Watch out: if a group of 20 calls is entered without a weight, it counts the same as a single call. Compare the median as well when a few very long calls may pull the mean up.
Sleep tracker or parent
Paste these values
23:50Watch out: plain arithmetic on clock times fails at midnight. 23:50, 00:10, and 00:35 average to about 08:11 with a plain formula, suggesting an average bedtime of 8 AM. Circular mean is the correct method, and it is what this calculator uses.
A basic mean treats every row as equal. Weighted average lets you attach importance, while running average shows how the result changes as more data arrives.
Enter each time followed by a comma and a weight, such as 4m 20s,3. The result is the total weighted time divided by total weight.
Turn on running average to see the cumulative mean after the first value, second value, third value, and so on.
4m 20s,3 3m 48s,1 5m 02s,2
The first value represents three calls, the second one call, and the third two calls. The result is weighted by the total number of observations, not just the number of rows.
| Duration | Weight | Contribution |
|---|---|---|
| 4m 20s | 3 | 780s |
| 3m 48s | 1 | 228s |
| 5m 02s | 2 | 604s |
42m 38m 51m 44m
| After value | Cumulative mean |
|---|---|
| 42m | 42:00 |
| 38m | 40:00 |
| 51m | 43:40 |
| 44m | 43:45 |
Running average shows how the central value changes as more evidence arrives, which is useful for trend monitoring and early detection of an unstable process.
The result panel shows more than one number. You can see the total, count, minimum, maximum, median, and range while you paste, so mistakes are easier to catch.
Paste mixed formats without splitting them into hour, minute, and second fields.
Give more weight to samples that represent more observations.
Watch the average change as each value is added to the set.
All calculations happen locally. Nothing leaves your browser.
Each metric answers a different question. The average is your central number, but the other values reveal whether your data is stable or full of outliers.
The central value, calculated from all entered values.
The shortest and longest values, useful for spotting extreme results.
The middle value after sorting, less sensitive to one extreme outlier.
Range shows duration spread. Clock time uses circular spread because midnight is not a normal boundary.
The right statistic depends on the question you are trying to answer. Average is a good default, median is better when outliers are common, and weighted average is necessary when some rows represent more observations than others.
| Use this | When you need | Example |
|---|---|---|
| Average | A central expected value from evenly meaningful observations. | Typical commute time from a week of daily trips. |
| Median | A typical value when one or two extreme results would distort the mean. | Average response time when a small number of tickets took hours. |
| Weighted average | A mean that accounts for how many observations each row represents. | Call center AHT when one row is a group of 20 calls. |
| Range or spread | A sense of variability around the central value. | Checking whether lap times are stable or becoming less consistent. |
A precise average is not the same as a reliable average. The summary panel gives you the supporting numbers needed to tell the difference.
Results keep milliseconds when they are present, so lap times, intervals, and response-time records are not rounded away unnecessarily.
One or two values cannot produce a stable average. The count makes it clear how much evidence supports the result.
When one value is unusually long or short, the median is a useful cross-check because it is less sensitive to that single result.
Clock times with a small spread are tightly grouped around the average. A large spread means the average may represent a wide range of times.
| Input | Correct interpretation |
|---|---|
| 23:50, 00:10 | Averages to about midnight because the two times are close together. |
| 23:00, 01:00 | Also averages to about midnight, not noon. |
| 00:00, 12:00 | The average is not defined because the times are evenly opposite on the clock. |
| Input | Interpretation |
|---|---|
| 42m, 38m, 51m, 44m | Average 43:45; range 13 minutes shows noticeable variation. |
| 45s, 46s, 45.5s | Average 45.5s; tight range means the process is stable. |
| 4m, 5m, 42m | Average is inflated by the 42-minute outlier; compare the median. |
If you prefer a spreadsheet, the same calculations are easy to reproduce. Store each value in a cell, convert it to a consistent unit, then apply the matching formula.
=AVERAGE(A2:A5)
Works directly when cells are formatted as time or when each cell contains the value in seconds.
=SUMPRODUCT(A2:A5,B2:B5)/SUM(B2:B5)
Use column A for time values and column B for the corresponding weights.
=AVERAGE($A$2:A2)
Drag this formula down the column to show the cumulative mean after each row.
=MOD(ATAN2(SUMPRODUCT(SIN(2*PI()*A2:A5/24)),SUMPRODUCT(COS(2*PI()*A2:A5/24)))*24/(2*PI()),24)
This formula treats time-of-day values as fractions of a 24-hour day. Format the result cell as a time.
For everyday use, this page is faster because it accepts mixed formats, handles the midnight problem automatically, and shows supporting statistics without building a spreadsheet.
Nothing on this page is a black box. Every algorithm maps to a standard spreadsheet function, so you can reproduce the result in Excel or Google Sheets. You do not need to take the tool on faith.
| Calculation | Spreadsheet formula | Where it appears |
|---|---|---|
| Duration average | =AVERAGE(A2:A5) | Duration mode result |
| Weighted average | =SUMPRODUCT(A2:A5,B2:B5)/SUM(B2:B5) | Weighted average toggle |
| Running average | =AVERAGE($A$2:A2) | Running average toggle |
| Median | =MEDIAN(A2:A5) | Median statistic |
| Min / max | =MIN(A2:A5) / =MAX(A2:A5) | Min and Max statistics |
| Standard deviation | =STDEV(A2:A5) | Std Dev statistic (duration mode) |
| Clock time circular mean | =MOD(ATAN2(SUMPRODUCT(SIN(2*PI()*A2:A5/24)),SUMPRODUCT(COS(2*PI()*A2:A5/24)))*24/(2*PI()),24) | Clock time mode result |
Enter 23:50 and 00:10 in clock mode. Plain math gives 12:00; the circular mean correctly gives 00:00.
Enter 00:00 and 12:00 in clock mode. The tool reports \"Not defined\" instead of inventing a meaningless middle point.
Paste 1:30.450, 90.25s, and 1h 23m on separate lines. Each value is normalized to seconds before averaging.
These are the documented functions and concepts behind the formulas on this page.
Average Time Calculator is an independent utility for people who work with time data. It is built to be faster than a spreadsheet and clearer than a single average, with no accounts, ads, or server-side data collection.
Built and maintained by the Average Time Calculator team
Midnight crossings and outlier cases are worked through below so you can verify the math.
No account, no sign-up, and no time data is uploaded or stored on a server.
Mixed formats, weighted records, CSV import, and shareable result links are supported.
Every formula is checked against public references and spreadsheet functions. Errors reported by users are corrected and logged publicly.
Every calculation is documented in the sections above and mapped to standard spreadsheet functions, so anyone can review the parser, the circular-mean math, and every calculation in this tool.
Each update is recorded here so visitors can see the page is actively maintained and reviewed.
The calculator is private by design. Time values never leave your browser.
All calculations run locally. Values are not uploaded, stored, or shared.
Your mode and options may be remembered on your device only.
Sharing encodes your input in the URL fragment; nothing is sent to a server.
No accounts, advertising networks, analytics, or cookies.
Add the calculator to your running, sleep, or workforce article. All calculations happen in the visitor's browser, so no time data is uploaded or stored.
Use the Share button in the calculator to copy a link that restores your current mode, values, and options.
<iframe src="https://www.average-time-calculator.com/embed" width="100%" height="720" loading="lazy" title="Average Time Calculator"></iframe>Most wrong results come from choosing the wrong interpretation, not from bad arithmetic.
Averaging 23:50 and 00:10 as ordinary numbers produces 12:00, which is wrong for times of day.
Mixing minutes, seconds, and decimal hours without normalizing them to the same unit can distort the result.
Pace and speed are reciprocal measures. Average lap duration is not the same as average lap speed.
A single very slow commute can make the mean look worse than the typical trip. Compare the median to catch this.
If some rows represent many observations, a plain average will underweight those groups.
Time data often includes rounding and manual entry error. Use count, min, max, and range to see how confident the average should be.
These definitions map directly to the result panel. If a term is unfamiliar, use this section to understand what the number means.
The central value calculated from all entered values. It is useful when the data is roughly balanced.
An amount of elapsed time, such as 1:30.45 or 3h 12m. Durations use ordinary arithmetic.
A point in the day, such as 11:45 PM. Clock times wrap every 24 hours and need circular averaging near midnight.
An average of angles rather than ordinary numbers. It prevents 23:50 and 00:10 from averaging to 12:00.
A mean where each value counts according to its weight, such as call volume or sample size.
The cumulative mean after each value in the list. It shows how the average changes as data arrives.
The middle value after sorting. It is less sensitive than the mean to one extreme observation.
The difference between the longest and shortest duration. It gives a quick sense of variability.
The circular equivalent of range for clock times. A small spread means the times are tightly grouped.
The number of valid values in the set. More values generally produce a more stable average.
Straight answers to the most common questions about averaging time values.
It is a tool that takes a set of time values and returns their mean. It also shows the total, count, minimum, maximum, median, and range so you can check the result instead of trusting a single number.
A duration is an amount of elapsed time, such as 1 minute 30 seconds. A clock time is a point in the day, such as 11:45 PM. The two need different math when values cross midnight.
Use duration mode when each value measures how long something took, such as lap times, commutes, workouts, or handling time. Use clock time mode when each value is a point in the day, such as bedtime, arrival time, or shift start time.
For durations stored as time values, use =AVERAGE(range). For weighted time, use =SUMPRODUCT(times,weights)/SUM(weights). For clock times, use a circular-mean formula that averages sine and cosine values over a 24-hour period. This page reproduces those calculations automatically.
Convert every value to a common unit such as seconds, add them together, and divide by the number of values. This page does that instantly and supports hours, minutes, seconds, milliseconds, and mixed formats.
For durations, use total seconds divided by the number of values. For clock times, convert each time to an angle on a 24-hour circle, average the sine and cosine components, and convert the resulting angle back to a time.
Paste call durations in duration mode. If some rows represent larger groups of calls, enable weighted average and add a weight after each time. Compare the median when a few unusually long calls may distort the mean.
For clock times, the page uses circular averaging. For example, 23:50 and 00:10 average close to 00:00, not 12:00. This is essential for sleep times, arrival times, and shift times.
You can paste HH:MM:SS, MM:SS, seconds, 1h 23m 45s, 1.5h, 45.5m, and 11:45 PM. In weighted mode, add a comma or tab followed by the weight for each value.
Yes. Turn on weighted average and enter each value with a weight, such as 4m 20s,3 or 4m 20s<TAB>3. The result is the total weighted time divided by the total weight.
Yes. Turn on running average to see the cumulative average after the first value, second value, third value, and so on.
Min is the shortest value, max is the longest, median is the middle value after sorting, and range is the difference between max and min.
Yes. Use Copy result or Download CSV. The download includes the mode, average, total, count, min, max, median, and range.
No. The page runs entirely in your browser. Time values are never uploaded, stored, or sent to a server.
Yes. You can mix HH:MM:SS, MM:SS, seconds, decimal hours, and unit expressions such as 1h 23m 45s. Each line is converted to seconds before calculating the average.
Multiply each time by its weight, add all weighted values together, then divide by the total weight. For example, 4m 20s,3 means this value represents three observations, not one.
Use the median when one very long or very short value would distort the mean. For example, one unusually slow commute should not hide the typical daily travel time.
Enable Average pace in duration mode and enter the distance each value covers, such as 0.4 km for a 400 m lap. The average time is divided by that distance to give the average pace per km or per mile. Note that average speed needs different math: convert each time to speed first, then average the speeds.
Yes. The parser accepts milliseconds in formats such as 1:30.450, 90.25s, and 1.5s. It also shows milliseconds in the result when needed.
No. This tool is designed for time durations and clock times within a single day. It does not add days, convert time zones, or account for daylight saving time.
A clock wraps around every 24 hours. Values near midnight are close together on a circle even though their hour numbers look far apart. Circular averaging keeps that geometry, so 23:50 and 00:10 average near 00:00.
Yes. The page is fully responsive and runs in any modern browser on a phone or tablet. Nothing needs to be installed, and all calculations still happen on your device.
No. You can enter any number of values, one per line. The result updates instantly regardless of list length, and CSV import makes it easy to bring in even larger lists.
Calculations run in full precision and are only rounded when displayed. Milliseconds are preserved when present, and because the math uses standard arithmetic, results match the spreadsheet formulas in the Spreadsheet section above.
Yes. Add query parameters to the URL, for example ?mode=duration&values=1:30%0A1:25 to enter two values, or add &weighted=1, &running=1, or &format=hhmmss. Each value is separated by %0A, the URL encoding for a new line.