In this tutorial, you will learn how to add time in Google Sheets.
If you’ve ever tried to perform calculations with times in Google Sheets, you’ll notice the answers don’t come out as you’d expect. For example, if you add any integer number to a time value, the result will be the same as the original time
It might seem like adding time in Google Sheets is impossible, or requires complex formulas, but fortunately it’s much easier than it seems once you understand how Google Sheets works with time
Understanding Time in Google Sheets
Google Sheets stores times and dates in much the same way. If you’ve ever done math with dates in Google Sheets, you’ll know that adding 1 to a given date will result in the date of the following day, as in the image below
Times work in the same way. Adding 1 to a given time is the same as adding an entire day, or 24 hours. This is why 9:00 AM + 1 is still 9:00 AM
If 1 is equal to 24 hours, then one hour is equal to 1 / 24, one minute is equal to 1 / (24*60), and one second is equal to 1 / (24*60*60)
With the above knowledge, adding time in Google Sheets becomes much easier. As an example, let’s say you want to calculate the time 1:20 minutes after a given time, here’s how you would do that:
Select the sell you want to perform the calculation in and enter the following formula: “=A11 + 1/24 + 20/(24*60)”. Where A11 is the cell in which the start time is stored
Hit enter and the added time will calculate
The above formula can be a little confusing to edit, but you can also store the hours and minutes in cells for easier updates in the future using this formula: “=A14 + B14/24 + C14/(24*60)”
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to add time in Google Sheets. Want more? Check out all the Google Sheets Tutorials.