Sometimes we are in need to **calculate time difference(s) in numbers **for various purposes. In this article, we are going to discuss some easy ways of it.

For further explanation, we are going to use a **Dataset **where the **Date**, **Arrival Time**, and ** Departure Time **of an institution are listed.

**Table of Contents**hide

## Download Practice Workbook

## 5 Easy Ways to Calculate Time Difference in Numbers

### 1. Using Simple Subtraction for the Calculation of Time Difference in Numbers

**Simple Subtraction** is actually a very simple way for the **calculation of time differences**.

**Steps**:

- Pick a cell for the output. I picked
**E5**in this case. - Write down the following formula:

`=D5-C5`

Here, **Subtraction **is done between the values in cells **D5 **and **C5**.

- Press
**ENTER**.

Now, we have the **calculated time difference in numbers **in cell **E5**.

- Use
**Fill Handle**to**AutoFill**the rests.

**Read More: Excel formula to find difference between two numbers**

### 2. Applying INT Function to Calculate Time Difference in Numbers

In order to **calculate **the** time difference in numbers**, we can also use **the INT function**.

**Steps**:

- Select a cell for the output. I selected cell
**E5**here. - Input the following formula:

`=INT((D5-C5)*24)`

Here, **Subtraction **is done between the values in cells **D5 **and **C5**. We multiply **24 ** with the **Subtracted Value **to convert it into **Hours**. Finally, we used **INT Function **to have the value in the integer number.

- Hit
**ENTER**.

We have the desired output in the selected cell.

- Now,
**AutoFill**the remaining cells.

**Similar Readings**

**How to Calculate Significant Difference Between Two Means in Excel****Pivot Table: Difference between Two Columns (3 Cases)****How to Calculate Difference Between Two Dates in Days in Excel**

### 3. Employing IF Function to Calculate Time Difference in Numbers

Another effective way to **calculate** the** time difference in numbers **is to use **the IF Function**.

**Steps**:

- Choose a cell to apply the
**IF Function**. Here, I picked the**E5**cell. - Write down the following formula:

`=IF((C5-B5)<0,1-(C5-B5),(C5-B5))`

Here, **Subtraction **is done between the values in cells **D5 **and **C5**. If the result is less than **0**, it will subtract that value from **1 **and will show a positive value. Otherwise, it will give the **Subtracted value**.

- Next, press
**ENTER**and we will have the desired result.

- Finally,
**AutoFill**the remaining cells.

**Read More:** **How to Calculate Absolute Difference between Two Numbers in Excel**

### 4. Using NOW Function to Calculate Time Difference in Numbers

**The NOW Function** is the easiest way to **calculate **the** time difference**. The output will automatically change with the passage of time.

**Steps**:

- Pick a cell for the output. I picked the
**E5**cell. - Input the following formula:

`=NOW()-C5`

Here, **Subtraction **is done between the values of **Present time **and in cell **C5**.

- Press
**ENTER**to have the result.

- Now,
**AutoFill**the rests.

### 5. Applying MOD Function to Calculate Time Difference in Numbers

We can use **the MOD Function** as well for the **calculation **of **time differences **in **numbers.**

**Steps**:

- Select a cell for the output. I selected cell
**E5**here. - Apply the following formula:

`=MOD(D5-C5,1)*24`

Here, **Subtraction **is done between the values in cells **D5 **and **C5**. Here, **1 **is the **divisor** given according to the need of the **MOD Function **which divides the **subtracted value**. Then, We multiply **24 ** with the **Subtracted Value **to convert it into **Hours**.

- Hit
**ENTER**.

We will have the output on the screen.

**AutoFill**the rests using**Fill Handle**.

## Practice Section

You can practice here for more expertise.

## Conclusion

I have tried to show **how to calculate **the** time difference in numbers **as simply as possible. I hope it will be helpful for Excel users. For any more questions, comment below.

## Related Articles

**How to Find Significant Difference Between Two Numbers in Excel****Difference Between Two Dates in Months in Excel (4 Suitable Examples)****Calculate Difference Between Two Rows in Pivot Table (with Easy Steps)****Pivot Table: Percentage Difference between Two Columns****Calculate Positive or Negative Difference Between Two Numbers in Excel**