How to average a range of times
✓ Verified in LibreOffice 25.8.7.3Find the mean of clock times or durations — average response time, average shift length.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =AVERAGE(A2:A6) | Format the result cell as a time (h:mm or [h]:mm). AVERAGE works on times because they're numbers. |
| Google Sheets | =AVERAGE(A2:A6) | Identical. |
| LibreOffice Calc | =AVERAGE(A2:A6) | Identical. |
How it works
Times are stored as fractions of a day, so AVERAGE handles them like any other number: the mean of 9:00, 10:00 and 11:00 is 10:00. The only catch is display — the raw result is a fraction, so format the cell as a time (h:mm), or [h]:mm if you're averaging durations that might exceed 24 hours. To average elapsed durations for pay or SLAs, multiply the result by 24 for decimal hours. Blank cells are ignored automatically; text-formatted times won't average until converted with TIMEVALUE.
Verified, not just documented
We ran =TEXT(AVERAGE(TIME(9,0,0),TIME(10,0,0),TIME(11,0,0)),"H:MM") in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned 10:00 — exactly the expected result. Every formula here is confirmed by actually executing it.