# How to Calculate Difference Between Two Times in Minutes in Excel

To calculate the difference between two times in minutes in Excel, follow these steps:

- Enter the two times in separate cells. For example, enter the start time in cell A1 and the end time in cell B1.
- In another cell, use the formula
`=(B1-A1)*24*60`

to calculate the difference between the two times in minutes. The formula subtracts the start time from the end time, multiplies the result by 24 (the number of hours in a day), and then multiplies that result by 60 (the number of minutes in an hour). - Press Enter to apply the formula and get the result.
- If the result is displayed as a time instead of a number, format the cell to display the result as a number. To do this, right-click the cell, select "Format Cells," choose "Number" in the "Category" list, and click "OK."

## Example

Let's say you want to calculate the difference between the start time 8:30 AM in cell A1 and the end time 2:15 PM in cell B1.

- Enter the start time in cell A1:
`8:30 AM`

- Enter the end time in cell B1:
`2:15 PM`

- In cell C1, enter the formula:
`=(B1-A1)*24*60`

- Press Enter. The result should be
`345`

, which represents the number of minutes between the two times.

Remember to format the result cell as a number if it's displayed as a time.

Did you find this useful?