You can use the following formula in Excel to convert minutes to hundredths:
=B2*24
This particular formula converts the minutes in cell B2 into a decimal with hundredths.
For example, if cell B2 contains 10:15 to represent 10 hours and 15 minutes, then this formula will return 10.25 to represent 10.25 hours.
The following example shows how to use this formula in practice.
Example: Convert Minutes to Hundredths in Excel
First, let’s enter the following dataset in Excel that shows the time (in hours and minutes) that it took for various athletes to finish some task:
Next, we can type the following formula into cell C2 to convert the minutes in cell B2 into a decimal with hundredths:
=B2*24
We can then click and drag this formula down to each remaining cell in column C:
By default, Excel will still use a time format.
To instead use a number format, highlight the cells in the range C2:C13, then click the Number Format dropdown menu from the Home tab along the top ribbon, then click Number:
The times in column C will now be shown in a decimal format:
For example:
- 10 hours and 15 minutes is equal to 10.25 hours.
- 4 hours and 29 minutes is equal to 4.48 hours.
- 2 hours and 22 minutes is equal to 2.37 hours.
And so on.
Additional Resources
The following tutorials explain how to perform other common operations in Excel:
Excel: How to Convert Time Duration to Minutes
Excel: Calculate Difference Between Two Times in Minutes
Excel: Calculate Difference Between Two Times in Hours
