Excel: Covert decimal hours Excel's hours & minutes (8.25 to 8:15)

Posted on: 02/17/2021 Excel: Covert decimal hours Excel's hours & minutes (8.25 to 8:15)

I'm frequently asked how to convert decimal hours to Excel's hour and minute format. A couple of examples: 7.75 need to show as 7:45, and 30.25 needs to show as 30:15. The solution is to divide by 24 hours. The formula is =hours/24. When you divide 7.75 by 24, you get 0.322917. After getting the answer, you format the time with an hour and minute format using Format Cells in Excel. The format is h:mm This works since one day (1) is 24 hours. 12 hours divided by 24 is 0.50.

YouTube Video

What about durations over 24 hours?

To display hours over 24 hours, recall I mentioned 30.25? Just adjust the number format. Just wrap the hours, which is the letter h in square brackets [h]:mm

How do I convert to minutes?

To convert to minutes, divide by 1440 instead of 24. 24 hours x 60 minutes = 1,440.

Excel file used in the video

One Excel file

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and Microsoft Most Valuable Professional (MVP). Chris works as a Senior Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel featuring over 900 technology videos that cover various apps, including Excel, Word, PowerPoint, Zoom, Teams, Coilot, and Outlook. To date, the channel has had over 25 million views. Menard also participates in 2 to 3 public speaking events annually, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.