How to Convert Decimal Time to Hours & Minutes in Excel

Microsoft Excel is a spreadsheet program that allows you to keep data, such as time. If you keep time in decimal form, you can convert it to regular hours and minutes. For example, if you have 0.5 hours, then you can use Excel to tell you it is 30 minutes. This allows you to make the calculation quickly without needing to worry about mistakes. After you format the formula right once, you can copy and paste it to use it again on other numbers.

Step

Type your hour in cell A1. For example, type "1.5" in cell A1.

Step

Type "=TEXT(A1/24, "h:mm")" in cell A2.

Step

Press "ENTER." In the example, your cell will say 1:30.