How to Add or Subtract Hours from a Date/Time Field in Excel?


When we want to add or subtract a specific time from a list where they are the combination of the date and time manually, then it will be a very complex and time-consuming process. This article will help us in solving this problem in a simple and efficient way. So let us see an article about how to add or subtract hours from any given date and time.

Adding Hours to a Date/Time Field

Here we will use the formula to get the first result, then use the auto-fill handle to complete the task. Let's go over a simple procedure for adding hours from a date/time field in Excel.

Step 1

Consider the data that contains a list of dates and times in a single cell, which is similar to the data shown in the below screenshot.

Now enter the formula as =A2+11/24. If we want to add 12 hours to the cell of A2 and click on Enter to get our first result, as shown in the below image,

Step 2

After getting the first result, we can get all the other results just by dragging from the first result until all the other results are filled, and our final output will look similar to the below screenshot.

Subtracting Hours from a Date/Time Field

Here, we will first use the formula to get the first result, then use the auto-fill handle. Let us see the process to know how we can subtract hours from a date/time field in Excel.

Step 1

Let us consider the same data that we have used in the above example.

Now to subtract 12 hours from the cell of A2, enter the formula as =A2+12/24 and click on enter to get our first result, as shown in the below image.

Step 2

After getting the first result, we can get all the other results just by dragging from the first result until all the other results are filled, and our final output will look similar to the below screenshot.

If the data is not visible in the result, then we need to format the cells as dd-mm-yyyy hh:mm in the custom.

Conclusion

In this tutorial, we used a simple example to demonstrate how we can add or subtract hours from data and time in Excel to highlight a particular set of data.

Updated on: 09-Jan-2023

6K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements