# How to Convert Time Duration to Minutes in Excel

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

- 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.
- 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.

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

## Example

- 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).
- In cell B1, enter the formula:

`=A1 * 24 * 60`

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

Did you find this useful?