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:

1. Enter the two times in separate cells. For example, enter the start time in cell A1 and the end time in cell B1.
2. 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).
3. Press Enter to apply the formula and get the result.
4. 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.

1. Enter the start time in cell A1: 8:30 AM
2. Enter the end time in cell B1: 2:15 PM
3. In cell C1, enter the formula: =(B1-A1)*24*60
4. 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.