How to Convert Time Value to Minutes in Excel Using Formula
To convert a time value to minutes in Excel, you can use a simple formula that multiplies the time value by 1440, which is the total number of minutes in a day. Excel stores time as decimals, where 1 represents 24 hours. When you multiply a time value by 1440, you get the equivalent number of minutes.
Formula to Convert Time Value to Minutes:
Follow these steps:
- Begin with the equal sign.
- Refer to the cell containing the time value.
- Use the asterisk (*) to multiply.
- Enter 1440.
- Press Enter to display the result.
The formula to use is: =A1*1440
Note: Once you enter the formula in a cell
Format the cell as “General” to display the total minutes as a number.
Convert Total Time to Minutes:
You can use the same formula to convert the total time of multiple time values into minutes.
Simply enter the formula in the cell where you want to display the result.