How to Add or Subtract Time in Google Sheets

How to Add or Subtract Time in Google Sheets

The Google Sheets logo

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:

Time addition sample Google Sheet

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.

Time format options inside Google Sheets

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.

Adding time in Google Sheets

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.

Resulting time in Google Sheets

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:

Time subtraction sample Google Sheet

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.

Time formatting options in Google Sheets

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 .

Time to subtract in Google Sheets

In the D2 mobile, we’ll enter the next system and push Enter:

=B2-C2

The resulting time will appear in the D2 cell.

Resulting time in Google Sheets

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:

Sample Google Sheet to find the time difference

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.

Time format options in Google Sheets

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.

The difference between the specified times

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