How to Convert Decimal Time to Hours & Minutes in Excel

By Carter McBride

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 1

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

Step 2

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

Step 3

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

References & Resources