How Do I Change Hours & Minutes Into a Decimal Number in Excel?. ... Using a quick equation, you can convert an existing set of time data written in "hh:mm" format to hours in decimal format.

If you've already entered time into a cell, you can easily reformat it to include hours, minutes and seconds using the Format Cells dialog. Insert Time Formula Select the cell you want to convert ...