Excel Formulas to Calculate the Work Hours between Dates and Times!!
Tags: excelformula, excelformulas
Published: 2021-05-24 05:04:32

---
title: Excel Formulas to Calculate the Work Hours between Dates and Times!!
published: true
date: 2021-05-21 04:14:23 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-calculate-work-hours-between-dates-times/
---

In the previous article, we have learned the formulas to **[get the working hours between two dates in Excel](https://geekexcel.com/excel-formulas-to-calculate-the-total-working-hours-between-two-dates/)**. 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](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Work hours between dates and times](https://geekexcel.com/wp-content/uploads/2021/05/Work-hours-between-dates-and-times.png)](https://geekexcel.com/excel-formulas-calculate-work-hours-between-dates-times/work-hours-between-dates-and-times/#main)<figcaption id="caption-attachment-44752">Work hours between dates and times</figcaption>

## General Formula:

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

**=([NETWORKDAYS](https://geekexcel.com/how-to-use-networkdays-function-in-ms-excel-365/)(start,end)-1)\*(upper-lower)+IF(NETWORKDAYS(end,end),[MEDIAN](https://geekexcel.com/how-to-use-excel-median-function-in-office-365-with-examples/)([MOD](https://geekexcel.com/how-to-use-excel-mod-function-in-office-365-with-examples/)(end,1),upper,lower),upper)-MEDIAN(NETWORKDAYS(start,start)\*MOD(start,1),upper,lower)**

## Syntax Explanations:

- **NETWORKDAYS** – The **[NETWORKDAYS Function](https://geekexcel.com/how-to-use-networkdays-function-in-ms-excel-365/)** 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**](https://geekexcel.com/how-to-use-excel-median-function-in-office-365-with-examples/).
- **MOD** – It helps to return the remainder of the two numbers after division. Read more on the **[MOD function](https://geekexcel.com/how-to-use-excel-mod-function-in-office-365-with-examples/)**.
- **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**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/05/Input-Ranges-43.png)<figcaption id="caption-attachment-44750">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-72.png)<figcaption id="caption-attachment-44753">Enter the formula</figcaption>

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

![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result1-2.png)<figcaption id="caption-attachment-44751">Result</figcaption>

## 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](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Related Articles:

- **[Excel Formulas to Get the Midpoint of the Project ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-to-get-the-midpoint-of-the-project/)**
- **[Excel Formulas to Calculate the Percentage of Completed Year ~ Easily!!](https://geekexcel.com/excel-formulas-to-calculate-the-percentage-of-completed-year/)**
- **[How to Find the Last Column of Data in Excel Office 365?](https://geekexcel.com/how-to-find-the-last-column-of-data-in-excel-office-365/)**
- **[Excel Formulas to Extract the Month From Date ~ Quick Tricks!!](https://geekexcel.com/excel-formulas-to-extract-the-month-from-date/)**