In this tutorial, you will learn how to subtract time in Google Sheets.
How to Subtract Time in Google Sheets
We can subtract seconds, minutes, and hours from a given time value in Google Sheets. This can be helpful if you need to retrieve the time value a specific duration prior to some time value.
For example, suppose you want to know the time 8 hours before an event that starts at 2:00 PM. We can use a simple formula to go back a specific length of time before a particular time.In this guide, we’ll show you how to subtract time in Google Sheets.
How to Calculate the Time Delta in Google Sheets
Here’s our step-by-step guide on how to calculate the time delta in Google Sheets.
Step 1
First, select the cell where you want to return the result of subtracting time from our initial time value.
In our first example, we will be subtracting a certain number of minutes from some initial time to create a new time value.
Step 2
If we want to subtract minutes from a time value, we must convert the number of minutes into a fraction of a day. We can do this by dividing the number of minutes by 60 (the number of minutes in an hour) and divide once more by 24 ( the number of hours in a day).
Afterward, we can subtract this new value from the initial time.
In our example, we find out that 45 minutes prior to 5:00pm is 4:15 PM.
Step 3
We can now use the AutoFill tool to find the new time values for the remaining rows.
Step 4
If we want to subtract by hours, we shall divide our number of hours by 24.
In the example above, we find out that 8 hours before 11:30 PM is 3:30 PM.
Summary
This guide should be everything you need to learn to subtract time in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.