You can use the following formula to sum a range of time durations in Google Sheets:
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:
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:
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: