In this tutorial, you will learn how to subtract time in Excel.
Consider a situation where you have to sum two different time values to obtain a total. Or, to calculate the overall time spent working on a project, you must divide one time value by another.
The tutorial will show you how simple it is to add or subtract time using Excel.
Once ready, we’ll get started by utilizing real-world examples to show you how to subtract time in Excel.
Table of Contents
Subtract Time in Excel
Before we begin we will need a group of data to be used to subtract time in Excel.
Step 1
First, you need a clean and tidy data group to work with. In this example, you will calculate the amount of time taken to run a 10km marathon for each individual in Excel.
Step 2
To subtract the times, you can simply enter this formula =C2-B2. Then we will need to change the format of the cell to show the value in hours and minutes instead of time. To do that, click on the cell, then right-click and select ‘Format Cells’.
Step 3
A pop-up box will then appear. Here you want to select ‘Number’, then select ‘h:mm’.
Step 4
Once you are done, apply the formula to the rest of your cells and your excel will look like this.
Summary
That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.
In this tutorial, I covered how to subtract time in Excel.