Browse » Home
Saturday, June 18, 2011
How to Change Minutes to Decimals in Excel
1. Double-click the Microsoft Excel file containing the time value you want to convert.
2. Find the cell location containing the time value that you want to convert to decimal format. For example, if your target cell were in column A, row 4, then the cell location would be 'A4.'
3. Click inside the cell in which you want to display the converted time.
4. Type '=(XX-INT(XX))*24' into the cell, replacing 'XX' with the location of the cell that you want to convert.
5. Press 'Enter' on your keyboard to execute the formula. Note that Excel will take 'AM' and 'PM' values into account, so '10:30 AM' and '10:30 PM' would have decimal values of '10.5' and '22.5,' respectively.