Naimul Hasan Arif
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.
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-C5Here, 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
- How to Find Difference Between Rows and Columns 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()-C5Here, 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)*24Here, 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
