*23*

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.

**Additional Resources**

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

How to Convert Timestamp to Date in Google Sheets

How to Sort by Date in Google Sheets

How to Compare Dates in Google Sheets

How to Add Months to Date in Google Sheets