Quick Tip - One Method to Use Excel to convert Chief's Time Tracker Durations.
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.
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.
