you might then use standard + and - operators to add and subtract the times in calculations.
Want to add, subtract, or find the difference (duration) between two times?
If so, Google Sheets makes it super easy to do just that, no function required.
We’ll show you how.
Start by opening your web internet tool, launchingGoogle Sheets, and accessing your spreadsheet.
We’ll then choose the C2 cell and choose Format > Number > Duration.
This is because this cell will display a time period and not the time itself.
We’ll add 5 hours, 54 minutes, and 28 seconds to the specified time.
To do that, we’ll poke the C2 cell and enter
.
This formula adds the time period in the C2 cell to the time in the B2 cell.
You’ll see the resulting time in the D2 cell.
And you’re all set.
Start by launching your spreadsheet onGoogle Sheets.
We’ll choose Format > Number > Duration for the C2 cell.
In the C2 cell, we’ll specify the time period to subtract from the B2 cell.
As an example, we’ll use 8 hours by entering8:00:00.
And that’s the resulting time after subtracting your specified time period from the source time.
If you’d like to extract hours from your result, then enter=HOUR(D2)in a cell.
To extract minutes and seconds, use=MINUTE(D2)and=SECOND(D2)in any cell, respectively.
That’s how you add, subtract, and find the time difference in your Google Sheets.
Want tocount the days between two dates in Google Sheets?
If so, it’s easy to do that too.
Related:How to Count the Days Between Two Dates in Google Sheets
