Table of Contents
Google Sheets is a spreadsheet program that allows users to perform calculations on data. To calculate the sum of time durations in Google Sheets, you can use the SUM function, which adds up a range of cells and returns the total sum. This function can also be used to add up time durations by converting them into a numerical format. For example, if you have a column of time durations in the format of hours, minutes, and seconds, you can use the SUM function to add them up and get the total duration. Simply select the cells containing the time durations, enter the SUM function, and press enter. The result will be the total sum of the time durations in a numerical format, which can then be converted back to the desired time format using the formatting options in Google Sheets.
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.
Cite this article
stats writer (2024). How do you calculate the sum of time durations in Google Sheets, and can you provide an example?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-you-calculate-the-sum-of-time-durations-in-google-sheets-and-can-you-provide-an-example/
stats writer. "How do you calculate the sum of time durations in Google Sheets, and can you provide an example?." PSYCHOLOGICAL SCALES, 26 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-you-calculate-the-sum-of-time-durations-in-google-sheets-and-can-you-provide-an-example/.
stats writer. "How do you calculate the sum of time durations in Google Sheets, and can you provide an example?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-you-calculate-the-sum-of-time-durations-in-google-sheets-and-can-you-provide-an-example/.
stats writer (2024) 'How do you calculate the sum of time durations in Google Sheets, and can you provide an example?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-you-calculate-the-sum-of-time-durations-in-google-sheets-and-can-you-provide-an-example/.
[1] stats writer, "How do you calculate the sum of time durations in Google Sheets, and can you provide an example?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do you calculate the sum of time durations in Google Sheets, and can you provide an example?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.