# How to Calculate Time Difference in Numbers (5 Easy Ways)

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. ## 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. 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. ### 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. ### 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 #### Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts 