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

Answer 1

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)

Answer 2

You can use a combination of functions. You need to find out how many hours are in the amount of minutes, so you need to divide by 60 and get the integer part of the result, using the INT function. You then need to find out the remaining minutes, using the MOD function. The TIME function can then be used to put the hours calculated and the minutes calculated together. You also then need to specify a zero for the seconds in the TIME function. Putting it all together, if you have 100 in cell A2, the full formula would be like this:

=TIME( INT( A2/60 ), MOD( A2,60 ), 0 )

Answer 3

To convert percentage of an hour into minutes, multiply the percentage by 0.6 .