How to Sum Time Duration in Google Sheets (With Example)

You can use the following formula to sum a range of time durations in Google Sheets:

=ARRAYFORMULA(TEXT(SUM(IFERROR(TIMEVALUE(C2:C8))), "[h]:mm:ss"))

This particular formula sums all of the time durations in the range C2:C8 and displays the result in a format of hours, minutes, and seconds.

The following example shows how to use this formula in practice.

Example: Sum Time Duration in Google Sheets

Suppose we have the following dataset in Google Sheets that shows the duration of various events:

Suppose we attempt to use the SUM() function to sum the time durations in column C:

=SUM(C2:C8)

It turns out that this formula will actually reset the sum to 0 each time the sum of the durations surpasses 24 hours:

Instead, we need to use the following formula to calculate the sum of the durations:

=ARRAYFORMULA(TEXT(SUM(IFERROR(TIMEVALUE(C2:C8))), "[h]:mm:ss"))

This formula correctly calculates the sum of the durations:

The sum of the values in the duration column turns out to be 44 hours, 53 minutes, and 6 seconds.

The following tutorials explain how to perform other common operations in Google Sheets: