How to Subtract Hours from Time in Excel (2 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will explain how to subtract hours from time in Excel. If we want to subtract any amount of hours from a particular time we can easily determine that by using different features of Excel. Microsoft Excel does not provide any special function to subtract hours from time. So, we will apply multiple functions or formulas to subtract hours from time in Excel.


How to Subtract Hours from Time in Excel: 2 Easy Ways

We will show you two easy ways to subtract hours from the time in Excel. To clarify the concept of this article, we will show you two easy ways to subtract hours from the time in Excel.


1. Subtract Less Than 24 Hours from Time in Excel

When we want to subtract a specific amount of hours from the time in Excel we need to consider some facts. The first thing we need to consider is whether the amount of hours we want to subtract is more than 24 hours or not. In this first method, we will demonstrate how to subtract hours from time if the subtraction amount is less than 24 hours.

1.1 Apply Fundamental Method to Subtract Hours

First and foremost, we will apply the basic method to subtract less than 24 hours from the time in Excel. From the dataset, we can see we have a schedule of starting times for six football matches. Suppose, all the matches have been rescheduled and will start 2 hours earlier. So, we need o to subtract 2 hours from the starting time of all the football matches.

Apply Fundamental Method to Subtract Hours

Let’s see the step-by-step guide of how we can subtract less than 24 hours from time:

STEPS:

  • Firstly, we will fix the time format like the dataset that we have given.
  • To do this, go to the Home tab. Click on the dropdown from the number section in the ribbon.
  • Then select More Number Formats”.

Apply Fundamental Method to Subtract Hours

  • Secondly, a new dialogue box will appear. Select the option “Time” from the Category.
  • Then from the Type section select the option “*1:30:00 PM” and press OK.
  • The above actions will set the time format for the worksheet as “*1:30:00 PM”.

  • Thirdly, select cell D5 and insert the following formula:
=C5-(2/24)
  • Then, press Enter.

Apply Fundamental Method to Subtract Hours

  • The above command subtracts 2 hours from the start time of cell C5 and returns output in cell D5.

  • After that, select cell D5. Move the mouse cursor to the bottom right corner of the selected cell so that it turns into a plus (+) sign like the following image.
  • Then, click on the plus(+) sign and drag the Fill Handle down to cell D10 to copy the formula of cell D5 in other cells. We can also double-click on the plus (+) sign to get the same result.

  • Now, release the mouse click.
  • Lastly, we can see the updated schedule for all matches after subtracting 2 hours from the start time.

Apply Fundamental Method to Subtract Hours

Read More: How to Subtract Time and Convert to Number in Excel


1.2 Subtract Hours with Excel TIME Function

We will do the previous task again with the same dataset that we used earlier. But, this time we will use the TIME function to subtract 2 hours from the start time of all the matches in the following image. The TIME function allows us to build a time with discrete parts for each hour, minute, and second.

Subtract Hours with Excel TIME Function

So, let’s the steps to use the TIME function to subtract time less than 24 hours:

STEPS:

  • First, select cell D5. Insert the following formula in that cell:
=C5-TIME(2,0,0)

Subtract Hours with Excel TIME Function

  • Next, press Enter. This action subtracts 2 hours from the start time of cell C5 and returns output in cell D5.

  • Then, select cell D5. Make the plus (+) sign visible like the following image by moving the mouse cursor to the bottom right corner of the selected cell.
  • After that, to copy the formula of cell D5 in other cells click on the plus (+) sign and drag the Fill Handle down to cell D10. Another way to do this is to double-click on the plus (+) sign to get the same result.

  • Now, release the mouse click.
  • Finally, we can see the new schedule for all matches after subtracting 2 hours from the start time.

Subtract Hours with Excel TIME Function

Read More: How to Subtract Minutes from Time in Excel


2. Excel Subtract More Than 24 Hours from Time

The above two methods are only applicable for subtracting less than 24 hours. If we want to subtract more than 24 hours from a specific time we have to use another approach. To illustrate this method we will use the same dataset but this time we also have dates with time and will subtract 26 hours from time. So, if we subtract more than 26 hours from a time the date will change automatically.

Excel Subtract More Than 24 Hours from Time

So, let’s see the steps regarding this method:

STEPS:

  • In the beginning, set the time format like the dataset. Here our time format is a Custom format.
  • Go to the Home Click on the dropdown from the Number section in the ribbon.
  • Then select “More Number Formats”.

Excel Subtract More Than 24 Hours from Time

  • Next, a new dialogue box will appear. From that box select the option Custom from the Category.
  • Type the format dd mmmm yyyy, hh:mm:ss AM/PM” in the box of the Type.
  • Now, press OK.
  • So, the above actions will fix the time format for the worksheet as dd mmmm yyyy, hh:mm:ss AM/PM”.

Excel Subtract More Than 24 Hours from Time

  • After that select, cell D5 and insert the following formula:
=C5-(26/24)

  • Now press Enter. This action subtracts 26 hours. We can see that the previous date of starting time was “28 February 2022, 12:30:00 PM” and the present start time is “27 February 2022, 10:30:00 PM”.

  • Next, to make plus (+) sign seeable like the following image select cell D5. Drive the mouse cursor to the bottom right corner of the selected.
  • Then, drag the Fill Handle down to cell D10 by clicking on the plus (+) This action copies the formula of cell D5 in other cells, or double-click on the plus (+) sign.

  • Finally, we can see the start time for all the matches after subtracting 26 hours.

Excel Subtract More Than 24 Hours from Time

Read More: How to Subtract Date and Time in Excel


Download Practice Workbook

You can download the practice workbook from here.


Conclusion

In conclusion, this article is a guide to subtract hours from time in Excel. To put your skills to the test, use the practice workbook that comes with this article. Please leave a comment below if you have any questions. Our team will try to reply as soon as possible.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , and premium Excel consultancy services for Excel and business users. Feel free to contact us with your Excel projects.
Mukesh Dipto
Mukesh Dipto

Hi there! I am Mukesh Dipto. I graduated with a bachelor's degree in engineering. Currently, I am working as a technical content writer in ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include sports and meeting new people. I also enjoy sports. My favorite sports are football (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo