How to Add or Subtract Time in Google Sheets

Structure the cells made up of times as either a particular time or period with Structure > Amount > Time or Length. You can then use standard + and – operators to increase and subtract the instances in calculations.
Want to add, subtract, or come across the variation (duration) among two situations? If so, Google Sheets tends to make it super easy to do just that, no operate demanded. We’ll display you how.
Include Time in Google Sheets
To increase several hours, minutes, or seconds to your specified time on Google Sheets, use the common “+” (as well as) operator.
Start by opening your internet browser, launching Google Sheets, and accessing your spreadsheet. We’ll use the next sheet as an case in point:
In this spreadsheet, we’ll use the subsequent cells:
- B2: This cell is made up of the start out time. We’ll insert our time to this time.
- C2: This is where we’ll specify the time to add.
- D2: This will display screen the ensuing time.
Considering that equally B2 and D2 will show real instances, we’ll format them to use the time format. To do that, we’ll pick individuals cells and select Format > Variety > Time from the menu bar.
We’ll then decide on the C2 mobile and pick Format > Quantity > Duration. This is mainly because this cell will screen a time period of time and not the time alone.
We’ll incorporate 5 several hours, 54 minutes, and 28 seconds to the specified time. To do that, we’ll click the C2 mobile and enter 5:54:28
.
In the D2 mobile, in which we want to exhibit the resulting time, we’ll enter the following formula and press Enter.
=B2+C2
This system adds the time time period in the C2 mobile to the time in the B2 cell. You will see the ensuing time in the D2 mobile.
And you’re all set.
If you’d like to consist of dates in your calculation, then find your cells and choose Structure > Number > Day Time from the menu bar.
Subtract Time in Google Sheets
To subtract time in Google Sheets, make use of the conventional “-” (minus) operator.
Start by launching your spreadsheet on Google Sheets. We’ll use the next sheet as an case in point:
In this spreadsheet, we’ll use these cells:
- B2: This mobile has the time from which you’ll be subtracting a time period.
- C2: This is exactly where you are going to outline the time interval to subtract.
- D2: This cell will clearly show the ensuing time.
We’ll pick out the B2 and D2 cells and make them use the time formatting by selecting Structure > Range > Time from the menu bar.
We’ll pick Format > Amount > Period for the C2 cell. In the C2 cell, we’ll specify the time interval to subtract from the B2 mobile. As an illustration, we’ll use 8 several hours by entering 8:00:00
.
In the D2 mobile, we’ll enter the next system and push Enter:
=B2-C2
The resulting time will appear in the D2 cell.
And that’s the ensuing time immediately after subtracting your specified time interval from the supply time.
Come across the Variance Concerning Two Specified Situations
To obtain the variation involving two periods (for case in point, how quite a few hours are concerning 9 a.m. and 6 p.m.), use the subsequent process.
We’ll use the beneath spreadsheet as an case in point:
In this spreadsheet, we’ve utilised the following cells:
- B2: This cell reveals the start time.
- C2: This cell shows the conclusion time.
- D2: This mobile will display screen the real time change concerning the start off and end situations.
Considering the fact that the B2 and the C2 cells will screen precise instances, we’ll time structure them by selecting Structure > Number > Time from the menu bar.
For the D2 mobile, we’ll pick Format > Selection > Period as it’ll screen the time duration in between the two specified occasions.
As you may perhaps have already guessed, we’ll come across the time big difference concerning 9:00:00 a.m. and 5:32:49 p.m. To do that, in the D2 cell, we’ll variety the following method and push Enter:
=C2-B2
In the D2 mobile, you are going to see the time distinction.
If you’d like to extract hours from your end result, then enter =HOUR(D2)
in a cell. To extract minutes and seconds, use =Minute(D2)
and =2nd(D2)
in any mobile, respectively.
That is how you include, subtract, and obtain the time distinction in your Google Sheets. Simple!
Want to rely the days involving two dates in Google Sheets? If so, it’s simple to do that too.
Related: How to Depend the Days Amongst Two Dates in Google Sheets