How to Add or Subtract Time in Google Sheets
Format the cells containing times as either a specific time or duration with Format > Number > Time or Duration. You can 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.
Add Time in Google Sheets
To add hours, minutes, or seconds to your specified time on Google Sheets, use the standard “+” (plus) operator.
Start by opening your web browser, launching Google Sheets, and accessing your spreadsheet. We’ll use the following sheet as an example:
In this spreadsheet, we’ll use the following cells:
- B2: This cell contains the start time. We’ll add our time to this time.
- C2: This is where we’ll specify the time to add.
- D2: This will display the resulting time.
Since both B2 and D2 will display actual times, we’ll format them to use the time format. To do that, we’ll…
Read Full Article Source