Using a quick equation, you can convert an existing set of time data written in "hh:mm" format to hours in decimal format.

Open the Excel 2010 file that you want to make format changes to. Select the top-left cell in the range of cells that you want to change to the accounting format.