You can use the following formula to calculate the difference between two times in hours in Excel:

**=(B2-A2)*24
**

This particular formula calculates the difference (in hours) between the times in cells **B2** and **A2**.

By default, the formula **B2-A2** would return the difference between cells **B2** and **A2** in terms of days.

Since there are 24 hours in a day, we must multiply the result of **B2-A2** by 24 to get the difference in terms of hours instead of days.

The following example shows how to use this formula in practice.

**Example: Calculate Difference Between Times in Hours in Excel**

Suppose we have the following two columns in Excel that show the start and end times for some events:

We can type the following formula into cell **C2** to calculate the difference between the start and end time for the first row in terms of hours:

**=(B2-A2)*24**

We can then drag and fill this formula down to each remaining cell in column C:

The values in column C display the difference in hours between the **Start Time** and **End Time** for each row.

Note that the time difference in the last row is greater than 24 because the difference between the **Start Time** and **End Time** for the last row is greater than one whole day.

**Note**: If you only want to know the difference between two times in terms of *whole hours*, you can use the following formula:

**=INT((B2-A2)*24)**

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel:

How to Calculate Average Time in Excel

How to Plot Time Over Multiple Days in Excel

How to Add & Subtract Hours from Time in Excel