Instant online tool
Average Time Calculator
Paste your times. Get the true average in seconds. No midnight math errors.
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
Stop calculating averages in spreadsheets. This tool handles mixed formats, midnight crossings, and weighted data so you get the right number instantly. Use it to find your real average commute, lap time, bedtime, or call handling time.
What is it?
What is an average time calculator?
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
The formula is simple. The edge cases are not.
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.
How to calculate average time, with examples
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.
Duration example: four lap times
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 |
367.55 seconds / 4 = 91.8875 seconds = 1:31.8875
Clock time example: crossing midnight
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 |
Why the duration method works
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
Why the clock method is different
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 θ)
How to use the average time calculator
The workflow is designed to be faster than a spreadsheet: paste, choose a mode, read the summary, and export.
01
Choose a mode
Select duration average for elapsed time or clock time average for times of day.
02
Paste or import
Enter one time value per line, paste from a spreadsheet, or import a CSV file.
03
Read the result
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 or share
Copy the summary, download CSV, or copy a shareable link with your current input.
Supported time formats
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 |
Built for the data you already have.
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.
Lap and race times
Compare average lap speed across a session and see the spread between your fastest and slowest effort.
Commute and travel time
Average a week of commutes to understand your realistic daily travel time.
Workout intervals
Track rest and work intervals, then find a target pace from the median rather than one outlier.
Call center AHT
Calculate average handling time with weighted values when some calls represent larger groups.
Sleep and routines
Find your average bedtime without the midnight problem distorting the result.
Task and project time
Turn scattered time logs into a clear average, total, and range for planning.
Step-by-step workflows
The same calculator, applied to three common jobs: a weekly call report, a training session, and a sleep log.
Call center AHT weekly report
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
Runner pacing and training
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
Sleep schedule statistics
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)
Average time by role and industry
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.
Not sure which mode fits your data? Pick your situation from the table below. Each row shows the right average time calculator mode and why the supporting statistics matter for your field.
| 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. |
Weighted and running averages, without the spreadsheet.
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.
Weighted average
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.
Running average
Turn on running average to see the cumulative mean after the first value, second value, third value, and so on.
Weighted example
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.
Weighted calculation, step by step
| Duration | Weight | Contribution |
|---|---|---|
| 4m 20s | 3 | 780s |
| 3m 48s | 1 | 228s |
| 5m 02s | 2 | 604s |
Weighted average = 1612 / 6 = 4:28.6667
Running average example
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.
Average, min, max, median, and range explained.
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.
Which number should you report?
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. |
Precision, rounding, and confidence.
A precise average is not the same as a reliable average. The summary panel gives you the supporting numbers needed to tell the difference.
Milliseconds and rounding
Results keep milliseconds when they are present, so lap times, intervals, and response-time records are not rounded away unnecessarily.
Count and sample size
One or two values cannot produce a stable average. The count makes it clear how much evidence supports the result.
Outliers and the median
When one value is unusually long or short, the median is a useful cross-check because it is less sensitive to that single result.
Circular spread
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.
How to read a circular clock-time result
| 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. |
How to read a duration result
| 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. |
Use the same formulas in Excel and Google Sheets
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.
Duration average
=AVERAGE(A2:A5)
Works directly when cells are formatted as time or when each cell contains the value in seconds.
Weighted average
=SUMPRODUCT(A2:A5,B2:B5)/SUM(B2:B5)
Use column A for time values and column B for the corresponding weights.
Running average
=AVERAGE($A$2:A2)
Drag this formula down the column to show the cumulative mean after each row.
Clock time circular average
=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.
Verify every calculation yourself
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. Google's own documentation, for example, defines the AVERAGE function as one that "returns the numerical average value in a dataset" (Google Support), and that is exactly the arithmetic this page applies to time values. 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 |
Midnight crossing
Enter 23:50 and 00:10 in clock mode. Plain math gives 12:00; the circular mean correctly gives 00:00.
Opposing times
Enter 00:00 and 12:00 in clock mode. The tool reports \"Not defined\" instead of inventing a meaningless middle point.
Mixed formats
Paste 1:30.450, 90.25s, and 1h 23m on separate lines. Each value is normalized to seconds before averaging.
References
These are the documented functions and concepts behind the formulas on this page. Each formula maps to a published source you can open to verify the math.
"Returns the numerical average value in a dataset, ignoring text."
Google — Google Sheets AVERAGE function. This page reproduces that same arithmetic for time values stored as durations."Calculates the sum of the products of corresponding entries in two equal-sized arrays."
Google — Google Sheets SUMPRODUCT function. That is exactly the weighted-average math used here."A mean of circular quantities" such as clock times, where the 24-hour wrap means 23:50 and 00:10 are close together.
Wikipedia — Circular mean. This page applies that definition in clock time mode."The sum of a collection of numbers divided by the count of numbers in the collection."
Wikipedia — Arithmetic mean. That is the duration-mode formula on this page.The mean "in which some elements of the data set carry more weight than others."
Wikipedia — Weighted arithmetic mean. Matches the weighted mode where a time with a larger weight counts more times."The value separating the higher half from the lower half of a data sample."
Wikipedia — Median. This page computes it to protect results against outliers."A measure of the amount of variation of a set of values."
Wikipedia — Standard deviation. The sample formula with n − 1 used here matches the spreadsheet =STDEV() function.
Embed, share, and keep it private.
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.
Share a result
Use the Share button in the calculator to copy a link that restores your current mode, values, and options.
Embed code
<iframe src="https://www.average-time-calculator.com/embed" width="100%" height="720" loading="lazy" title="Average Time Calculator"></iframe>Live preview
Common mistakes when averaging time
Most wrong results come from choosing the wrong interpretation, not from bad arithmetic.
Treating clock time as duration
Averaging 23:50 and 00:10 as ordinary numbers produces 12:00, which is wrong for times of day.
Ignoring units
Mixing minutes, seconds, and decimal hours without normalizing them to the same unit can distort the result.
Using average pace as average speed
Pace and speed are reciprocal measures. Average lap duration is not the same as average lap speed.
Letting one outlier dominate
A single very slow commute can make the mean look worse than the typical trip. Compare the median to catch this.
Forgetting weights
If some rows represent many observations, a plain average will underweight those groups.
Assuming the result is precise
Time data often includes rounding and manual entry error. Use count, min, max, and range to see how confident the average should be.
Time-average terms explained
These definitions map directly to the result panel.
Mean / average
The central value calculated from all entered values.
Duration
An amount of elapsed time, such as 1:30.45 or 3h 12m.
Clock time
A point in the day, such as 11:45 PM. Needs circular averaging near midnight.
Circular mean
An average of angles rather than numbers, so 23:50 and 00:10 average near midnight.
Weighted average
A mean where each value counts according to its weight, such as call volume.
Running average
The cumulative mean after each value in the list.
Median
The middle value after sorting, less sensitive to one extreme observation.
Range
The difference between the longest and shortest duration.
Circular spread
The circular equivalent of range for clock times.
Sample size
The number of valid values in the set.
Frequently asked questions
Straight answers to the most common questions about averaging time values.
What is an average time calculator?+
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.
What is the difference between duration and clock time?+
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.
How do I choose between duration and clock time?+
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.
How do I calculate average time in Excel or Google Sheets?+
For durations, use =AVERAGE(range). For weighted time, use =SUMPRODUCT(times,weights)/SUM(weights). For clock times, use a circular-mean formula over a 24-hour period.
What formats can I paste?+
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.
Can I calculate a weighted average time?+
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.
Can I calculate a running average time?+
Yes. Turn on running average to see the cumulative average after the first value, second value, third value, and so on.
What are min, max, median, and range in time data?+
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.
Can I export results?+
Yes. Use Copy result or Download CSV. The download includes the mode, average, total, count, min, max, median, and range.
Is my data stored?+
No. The page runs entirely in your browser. Time values are never uploaded, stored, or sent to a server.
Why does clock time use circular average?+
A clock wraps every 24 hours. Values near midnight are close together on a circle even though their hour numbers look far apart. So 23:50 and 00:10 average near 00:00.
Can I use the average time calculator on my phone?+
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.