Quick Tip - One Method to Use Excel to convert Chief's Time Tracker Durations.

[Kbird1]

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 1^st Cell of the Data to be converted.

 

 In my case below the cell is C4   (underlined in RED)   so      =HOUR(C4)+MINUTE(C4)/60

 

 

You also need to make sure that the cells are formatted correctly.

 

 Select the CA Duration Time  column, (C in pic above) right click and select “Format Cells” and select Custom,

 and then h:mm   ( if needed type in the h:mm where it says Type)

  

 

 

 

 

You also need to make sure that the Formula  RESULT Column cells are formatted correctly.

Do the same for your Decimal Time column……but set it to Number with  2 decimals,

remembering the Result you see is in Decimal Hours  NOT Hours and Minutes,  ie 1.30  is 1.3 hours not  1 hr 30 mins.

 

You will now have Time in a Numbers   Decimals format which the AutoSum Feature should add together with no problems.

     ie  =SUM(D4:D17)         for this Image below  

 

 

 

 

You can then select the Cell with the Formula in it , hover over the bottom right corner for the

cross icon and then grip it and pull down the column and Excel will fill in the result for all Cells automatically.

 

 

 

 

  

  

 

 

Updated March 12th 2022.

 

 

M.

 

 

.

[Kbird1]

Updated PDF ( top of Post 1 ) for a Cell No# Error and Excel Beginners after re-rereading it Myself.

 

M.