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.

In addition to its basic spreadsheet functions, Microsoft Excel also allows writing formulas to perform functions on existing data. Using a quick equation, you can convert an existing set of time ...

SEE: 83 Excel tips every user should master (TechRepublic) In this Microsoft Excel tutorial, I’ll show you four easy ways to convert numbers stored as text to real numbers.