Converting a decimal time value to minutes and hours is easily done in Excel. That is, if the time value is less than 24 hours.
Decimal to Time Conversion
Here are three simple steps to convert decimal to time.
- Enter a decimal value into a cell
- Divide by 24
- Change cell formatting to Time (h:mm)
To change the cell format use keyboard shortcut Ctrl+1 to bring up the Format Cells dialog box, select the Number tab, click Time, then select the h:ss format as shown below.
If you have a lot of conversions then one column for the decimal values and another column for a formula dividing by 24 will suffice. Just change the formatting for the second column. The example above shows three columns for illustrative purposes and is not very practical.
Obviously a conversion can be done in one cell, if you:
- Enter a formula into a cell with a decimal value divided by 24 (=0.61/24)
- Format that cell to h:mm
And remember, this only works properly for decimal values less than 24 hours.