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 … Read the rest