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.

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

Leave a Reply

Your email address will not be published.