Do you ever find yourself needing to subtract hours in Excel? If so, you’re in the right place. In this guide, you’ll learn how to subtract hours in Excel in a few easy steps. Whether you’re a beginner or an experienced user, this guide will help you understand how to subtract hours in Excel quickly and easily. Let’s get started!

How to Subtract Hours in Excel?

Subtract Hours from a Single Date

Subtracting hours from a single date in Excel is a relatively easy process. To do this, you will need to use the DATEVALUE function. This function will take a string of text and convert it into a date. It also allows you to subtract hours from the date. To subtract hours from a single date in Excel, follow these steps:

Step 1: Enter the DateValue Function

Open the Excel sheet where you want to subtract hours from a date. Enter the DateValue function with the date string you wish to convert in the parentheses. For example: DateValue(“10/25/2020”). This will convert the text into a date format.

Step 2: Subtract Hours

Once the date is converted, subtract the number of hours you want to subtract from the date. For example: DateValue(“10/25/2020”) – 12. This will subtract 12 hours from the date.

Step 3: Format the Date

Once you have subtracted the hours, you can format the date to display it in the format you want. To do this, select the cell with the date and click the “Format Cells” button in the Home tab. Select the format you want and click “OK” to apply the format.

Subtract Hours from Multiple Dates

Subtracting hours from multiple dates in Excel is slightly more complicated than subtracting from a single date. To do this, you will need to use the TIMEVALUE function. This function will take a string of text and convert it into a time format. It also allows you to subtract hours from the time. To subtract hours from multiple dates in Excel, follow these steps:

Step 1: Enter the TimeValue Function

Open the Excel sheet where you want to subtract hours from multiple dates. Enter the TimeValue function with the time string you wish to convert in the parentheses. For example: TimeValue(“10:00am”). This will convert the text into a time format.

Step 2: Subtract Hours

Once the time is converted, subtract the number of hours you want to subtract from the time. For example: TimeValue(“10:00am”) – 12. This will subtract 12 hours from the time.

Step 3: Format the Time

Once you have subtracted the hours, you can format the time to display it in the format you want. To do this, select the cell with the time and click the “Format Cells” button in the Home tab. Select the format you want and click “OK” to apply the format.

Subtract Hours from a Date Range

Subtracting hours from a date range in Excel is slightly more complicated than subtracting from a single date or multiple dates. To do this, you will need to use the SUBTOTAL function. This function allows you to subtract hours from a range of dates. To subtract hours from a date range in Excel, follow these steps:

Step 1: Enter the Subtotal Function

Open the Excel sheet where you want to subtract hours from a date range. Enter the Subtotal function with the range of dates you wish to subtract hours from in the parentheses. For example: SUBTOTAL(2, A1:A5). This will subtract hours from the range of dates.

Step 2: Subtract Hours

Once the range of dates is selected, subtract the number of hours you want to subtract from the date range. For example: SUBTOTAL(2, A1:A5) – 12. This will subtract 12 hours from the date range.

Step 3: Format the Date Range

Once you have subtracted the hours, you can format the date range to display it in the format you want. To do this, select the cell with the date range and click the “Format Cells” button in the Home tab. Select the format you want and click “OK” to apply the format.

Related Faq

Q1: How do I subtract two hours from a given time in Excel?

A1: To subtract two hours from a given time in Excel, you can use the TIME function. This function takes three arguments, the hours, minutes and seconds, and returns a serial number representing the time. For example, to subtract two hours from a time of 10:00 AM, you could use the formula TIME(8,0,0) which will return a serial number that corresponds to 8:00 AM. You can then add or subtract this serial number from the original time to get the resulting time.

Q2: How do I subtract a specified number of minutes from a given time?

A2: To subtract a specified number of minutes from a given time, you can use the MINUTE function. This function takes two arguments, the hour and the minute, and returns the number of minutes since midnight. For example, to subtract 10 minutes from a time of 10:05 AM, you could use the formula MINUTE(10,5)-10 which will return a serial number that corresponds to 9:55 AM. You can then add or subtract this serial number from the original time to get the resulting time.

Q3: How do I subtract a specified number of seconds from a given time?

A3: To subtract a specified number of seconds from a given time, you can use the SECOND function. This function takes two arguments, the hour and the second, and returns the number of seconds since midnight. For example, to subtract 5 seconds from a time of 10:05:05 AM, you could use the formula SECOND(10,5,5)-5 which will return a serial number that corresponds to 10:05:00 AM. You can then add or subtract this serial number from the original time to get the resulting time.

Q4: How can I subtract a specified number of hours, minutes and seconds from a given time?

A4: To subtract a specified number of hours, minutes and seconds from a given time, you can use the TIME function. This function takes three arguments, the hours, minutes and seconds, and returns a serial number representing the time. For example, to subtract 1 hour, 10 minutes and 5 seconds from a time of 10:00 AM, you could use the formula TIME(8,50,55) which will return a serial number that corresponds to 8:50:55 AM. You can then add or subtract this serial number from the original time to get the resulting time.

Q5: How can I subtract a specified number of days from a given date?

A5: To subtract a specified number of days from a given date, you can use the DATE function. This function takes three arguments, the year, month and day, and returns a serial number representing the date. For example, to subtract 7 days from a date of 01/01/2020, you could use the formula DATE(2020,1,1)-7 which will return a serial number that corresponds to 12/25/2019. You can then add or subtract this serial number from the original date to get the resulting date.

Q6: How do I subtract a specified number of years from a given date?

A6: To subtract a specified number of years from a given date, you can use the YEAR function. This function takes two arguments, the year and month, and returns the number of years since 1900. For example, to subtract 3 years from a date of 01/01/2020, you could use the formula YEAR(2020,1)-3 which will return a serial number that corresponds to 01/01/2017. You can then add or subtract this serial number from the original date to get the resulting date.

How to Calculate Time in Excel / Add Time, Subtract Time Excel – Tutorial ⏰

Subtracting hours in Excel is a simple and straightforward process. With the use of the subtraction operator, you can quickly and easily subtract the number of hours from a given time. You can also use the MINUS function to subtract hours from a given time. By following the steps outlined above, you can subtract hours from a time in Excel quickly and accurately. With this guide, you’ll be able to master the art of subtracting hours in Excel in no time.