How to sum time in Google Sheets
Click the cell for the total and enter =SUM(range), for example =SUM(A2:A100). Or select the numbers and read the sum in the bottom-right explore/status area, then click it to paste. SUM ignores text; use SUMIF/SUMIFS when you need conditions.
Steps
-
1
Click the result cell.
-
2
Type =SUM( and select the range.
-
3
Press Enter.
-
4
Use SUMIF if you need criteria.
Related tutorials
These videos might help you go deeper on this topic.
Create a Timer with Apps Script
Build a Visual Clock
How to Insert Multiple Rows in Google Sheets (Easy to Hard)
Add NPS to Your Google Site
Create a Stop Watch in a Google Sheet
Related blog posts
Written guides that go deeper on this question.
How To Create a Stop Watch in Google Sheets
Create a Stop Watch in a Google Sheet. Start and stop time stamps, add up duration once you click. This is a sweet Google Sheet to make and you can see it step-by-step.
Read post →How To Hide Data with Checkboxes in Google Sheets
Google Sheets, Google Sheets Tutorials | This tutorial is meant to show you not just what magical things you can do with checkboxes, but also to show you my process on how when you become a member of Better Sheets.
Read post →How to Make a Year at a Glance in Google Sheets
Build a year at a glance in Google Sheets: 12 month rows, 31 day columns and weekend shading from two formulas. Or copy the free Big Year and skip it.
Read post →Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
Explore tab
The Explore tab is a sidebar panel that analyzes your selected data and suggests charts, pivot tables, formatting, an...
Open →SUMIF
SUMIF totals values in a sum_range when a matching row in criteria_range meets your criterion. It is the classic sing...
Open →SUMIFS
SUMIFS adds values in sum_range only when every criteria_range passes its paired test. Argument order is sum_range fi...
Open →SUM()
Google Sheets SUM() function guide
Open →SUMIF()
Google Sheets SUMIF() function guide
Open →SUMIFS()
Google Sheets SUMIFS() function guide
Open →TIME()
Google Sheets TIME() function guide
Open →Related questions
Why is my sum 0 in Google Sheets
Click the cell for the total and enter =SUM(range), for example =SUM(A2:A100). Or select the numbers and read the sum in the bottom-right explore/status area, then click it to paste. SUM ignores text; use SUMIF/SUMIFS when you need conditions.
Get the answer →Where is sum in Google Sheets
Click the cell for the total and enter =SUM(range), for example =SUM(A2:A100). Or select the numbers and read the sum in the bottom-right explore/status area, then click it to paste. SUM ignores text; use SUMIF/SUMIFS when you need conditions.
Get the answer →How to sum dropdown in Google Sheets
Click the cell for the total and enter =SUM(range), for example =SUM(A2:A100). Or select the numbers and read the sum in the bottom-right explore/status area, then click it to paste. SUM ignores text; use SUMIF/SUMIFS when you need conditions.
Get the answer →How do i sum a column in Google Sheets
Click the cell for the total and enter =SUM(range), for example =SUM(A2:A100). Or select the numbers and read the sum in the bottom-right explore/status area, then click it to paste. SUM ignores text; use SUMIF/SUMIFS when you need conditions.
Get the answer →How to sum in Google Sheets
Click the cell for the total and enter =SUM(range), for example =SUM(A2:A100). Or select the numbers and read the sum in the bottom-right explore/status area, then click it to paste. SUM ignores text; use SUMIF/SUMIFS when you need conditions.
Get the answer →Need more than a quick answer?
600+ walkthrough videos, unlimited generators, and every template. From $9/month. Practical lessons. Zero fluff.
Need one fix
Watch a free tutorial for the step-by-step version of any answer.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.