# 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.