Chief Time Conversion Using an Excel Formula By Mick – aka Kbird1 on the Chief Help Forums   PDF FILE FOR DOWNLOAD :   How to Convert Time to Decimal in Microsoft Excel 1.pdf    *** I am not a Excel Expert , this is just how I do it.....   First, create a new column if needed ( for me CA does this automatically??? ) and enter the formula :    =HOUR(cellno#)+MINUTE(cellno#)/60   Where (cell no#) is the 1st Cell of the Data to be converted.