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.

How to convert time values into decimal values in Excel Internally, Excel stores the time as a decimal value. The quickest way to see that time value is to change the format.