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


Kbird1
 Share

Recommended Posts

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.

 

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

 

image.thumb.png.67ce94f4ab5097c1ef912cfdfeb9c262.png

 

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)

  

 

 image.thumb.png.33fcb560667e9383906833f9846aee46.png

 

 

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  

 

 image.thumb.png.6e6a071bac318f506336ca5233d66553.png

 

 

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.

 

 

 image.thumb.png.787efd0258696fe0203e129aebce1eb9.png

 

 image.thumb.png.ceeef3998e045c756c50ca956a3cd066.png 

  

 

 

Updated March 12th 2022.

 

 

M.

 

 

.

  • Like 1
  • Upvote 1
Link to comment
Share on other sites

  • 2 years later...

Thanks for sharing this Excel tip! I've been using Excel for years, and these kinds of formulas can be real lifesavers. Back when I upgraded to Microsoft Office Professional Plus 2021, I found myself diving deeper into Excel functionalities like this. It really streamlined my data handling tasks, especially when dealing with time conversions and calculations. Keep sharing these tips—they make a big difference for us spreadsheet enthusiasts!

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share