How to Convert Time Duration to Minutes in Excel

To convert a time duration to minutes in Excel, you can use the following steps:

1. Ensure that the time duration is in a proper time format (hh:mm:ss). If it's not, you can format the cell by right-clicking on the cell, selecting "Format Cells," and then choosing "Time" under the "Number" tab.
2. In another cell, use a formula to multiply the time duration by 24 (hours) and then by 60 (minutes) to get the total number of minutes. The formula should look like this:

=time_duration_cell * 24 * 60

Replace "time_duration_cell" with the cell reference containing the time duration.

3. Press Enter, and the total number of minutes will be displayed in the cell.

Example

1. Let's say you have a time duration of 2 hours, 30 minutes, and 0 seconds in cell A1. Ensure that it's formatted as a time value (02:30:00).
2. In cell B1, enter the formula:

=A1 * 24 * 60

3. Press Enter. Cell B1 should now display the total number of minutes, which is 150 in this case.