How to Convert Time to Decimal Format Converting time to decimal format just involves basic division. There are 24 hours in a day, 60 minutes in an hour and 60 seconds in a minute.

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 ...