Kbird1 Posted March 9, 2022 Share Posted March 9, 2022 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 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. . 1 1 Link to comment Share on other sites More sharing options...
Kbird1 Posted March 13, 2022 Author Share Posted March 13, 2022 Updated PDF ( top of Post 1 ) for a Cell No# Error and Excel Beginners after re-rereading it Myself. M. 1 Link to comment Share on other sites More sharing options...
Lensytink Posted July 12 Share Posted July 12 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 More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now