How do you convert percentage of an hour into minutes in excel?

If you have a value of 3.4 hours in cell A1 and you want in to be converted to 3 Hours 24 Minutes into another cell, type this formula into the cell you wish to display Hrs and Mins:

=ROUNDDOWN(A1,0)&" "&"Hours"&" "&((A1-ROUNDDOWN(A1,0))*60)&" "&"Minutes"

If you want the 3.4 in cell A1 to show as 3:24, type this formula into the cell you want it to be displayed:

=ROUNDDOWN(A1,0)&":"&((A1-ROUNDDOWN(A1,0))*60)