Excel Formulas to Calculate the Work Hours between Dates and Times!!

In the previous article, we have learned the formulas to get the working hours between two dates in Excel. But if you need to find out the work hours between dates and times , how could you get it quickly? This article will introduce several tricks to solve them in Excel easily. Let’s step into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

If you want to get the total working hours between the given date and time, you can use the below formula.

=(NETWORKDAYS(start,end)-1)*(upper-lower)+IF(NETWORKDAYS(end,end),MEDIAN(MOD(end,1),upper,lower),upper)-MEDIAN(NETWORKDAYS(start,start)*MOD(start,1),upper,lower)

Syntax Explanations:

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

MEDIAN – This function returns the median (middle number) from the given set of input numbers. Read more on the MEDIAN Function.

MOD – It helps to return the remainder of the two numbers after division. Read more on the MOD function.

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.

Plus operator (+) – This symbol is used to add the values.

Minus Operator (-) – This symbol will help to subtract any two values.

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.

Example:

Let’s consider the below example image.

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

Now we need to calculate total working hours between two dates and times, that occur between a “lower” and “upper” time which is given in Column G.

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.

Wind-Up:

From this guide, you can get some clarification on how to calculate the total work hours between dates and times in Exce l. Hope you like it. Please share your query below in the comment box. We will assist you.

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

Excel Formulas to Get the Midpoint of the Project ~ Easy Tricks!!

Excel Formulas to Calculate the Percentage of Completed Year ~ Easily!!

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

Excel Formulas to Extract the Month From Date ~ Quick Tricks!!