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 Use Google Sheets for Advanced Project Management
Master Google Sheets for project management with these advanced tips. Check our free tutorials, tools, and templates for data management, task flow, and much more.
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.