# How to calculate time difference in excel

**URL:** <https://sorumatik.co/t/how-to-calculate-time-difference-in-excel/13337>\
**Category:** Computer Science\
**Created:** [Mart 30, 2023, 10:30öö UTC](https://sorumatik.co/t/how-to-calculate-time-difference-in-excel/13337 "2023-03-30T10:30:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dersnotu](https://sorumatik.co/user_avatar/sorumatik.co/dersnotu/32/3037_2.png) [@Dersnotu](https://sorumatik.co/u/Dersnotu)\
**Post date:** [Mart 30, 2023, 10:30öö UTC](https://sorumatik.co/t/how-to-calculate-time-difference-in-excel/13337/1 "2023-03-30T10:30:57Z")

</div>

how to calculate time difference in excel

---

<div class="post-metadata">

**Author:** ![Dersnotu](https://sorumatik.co/user_avatar/sorumatik.co/dersnotu/32/3037_2.png) [@Dersnotu](https://sorumatik.co/u/Dersnotu)\
**Post date:** [Mart 30, 2023, 10:31öö UTC](https://sorumatik.co/t/how-to-calculate-time-difference-in-excel/13337/2 "2023-03-30T10:31:51Z")

</div>

How to calculate time difference in excel?

**Answer:** To calculate time difference in Excel, you can use the subtract function. Here are the steps:

1. Enter the start time in one cell and the end time in another cell. Make sure that both cells are formatted as “Time”.

2. In a third cell, enter the formula “=end\_time-start\_time”. This will give you the time difference between the two times.

3. To format the result as a time, right-click on the cell and select “Format Cells”. In the Number tab, select “Time” as the Category and choose the formatting that you prefer[.](https://sorumatik.co/t/how-to-calculate-time-difference-in-excel/13337)

Note that the result of the subtraction may be displayed as a negative value if the end time is earlier than the start time. In this case, you can either switch the order of the times or use the ABS function to display the absolute value of the time difference.