Excel Formulas to Calculate the Total Working Hours Between Two Dates!!

In many companies, employers are paid by working hours. To calculate the work hours in a day is easy, but how about calculating working hours in a date range? For that, this article introduces the formulas to calculate the total working hours between two dates excluding weekends and holidays in Excel. Let’s get into the topic!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

To calculate the work hours between two dates you can use the below formula.

Syntax Explanations:

NETWORKDAYS – The NETWORKDAYS Function returns the number of working days between two dates.

Start – It specifies the starting date from your worksheet.

*End * – It represents the end date from your worksheet.

Hours – It specifies the number of working hours per day.

Multiplication (*) – In this symbol will multiply any two values or numbers.

Comma symbol (,) – It is a separator that helps to separate a list of values.

Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Refer to the below example image.

First, we will enter the input values such as starting date , ending date in Column B and Column C.

Here, we have to find out the total working hours between these two input ranges excluding weekends and holidays which is given in Column F.

We will define the total working hours per day as 8.

Select any cell and type the above-given formula.

Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.

Wrap-Up:

Hope you like this article on how to calculate the total working hours between two dates in Excel. Let me know if you have any doubts regarding this article or any other Excel/VBA topic.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Read Also:

Excel Formulas to Calculate the Week Number of the Given Date!!

Excel Formulas to Calculate the Quarter from the Given Date ~ Easy Tips!!

How to Find the Last Column of Data in Excel Office 365?

Excel Formulas to Find the Same Date in Next Year ~ Simple Guide!!