Convert a Number to No.of Days, Hours & Minutes:-

To convert a number to Number of Days, Hours and Minutes do the following steps:

1. Enter a number in A1 cell of your Excel sheet.
2. Place the following formula in a cell in which you require the output.

Formula:
=IF(A1<1440,(INT(A1/60)&" Hrs "&MOD(A1,60)&" Min"),(INT(A1/1440)&" Days "&INT((MOD(A1,1440))/60)&" Hrs "&MOD((MOD(A1,1440)),60)&" Min"))

3. Now press enter to get the require output.

Note: In some versions of Excel, you may have to use ";" instead of  "," when you define a formula.