How to Convert Decimals to Days Hours and Minutes in Excel

This worksheet contains decimals in Column B.

To convert the decimals to days hours and minutes, use the TEXT and INT functions, and Custom Format. Here’s an overview: convert decimal to days hours and minutes in excel

Method 1 – Using the TEXT Function to Convert Decimals to Days Hours and Minutes in Excel

Step 1:

Select a cell to see the output. Here, C5.

Enter the formula.

=TEXT(B5/24, " d\d h\h m\m")

B5/24 is the decimal value and “ d\d h\h m\m” is the format_text.

Press ENTER.
51 decimal values were converted to 30d 3h 30m.

Step 2:

Drag down the Fill Handle to see the result in the rest of the cells.

Method 2 – Combining the INT and the TEXT Functions to Convert Decimals to Days Hours and Minutes in Excel

Use the INT function and the TEXT function.

Step 1:

Select C5.

Enter the formula.

=INT(B5/24) & "days " & TEXT(B5/24, " h\h m\m")

Formula Breakdown:

B5/24 is the decimal value and the INT function converts it into days.
B5/24 is the decimal value of the TEXT function and “ h\h m\m” is the format_text. The TEXT function converts it into hours and minutes.