convert from percentage of time to time using complex formula in .

[Guest]

I am doing a report from a system that works in a percentage of an hour, for
example 0.50 is equal to 30mins, 1.32 is equal to 118mins. is there a formula
in excel that can work this out?

 

[Guest]

Apart from the fact that 118 minutes can never be 1.32 hours, if you multiply
by 60, you'll get pretty close. However, 118 minutes is equal to about 1.97
hrs.

 

[Bernard Liengme]

For time, Excel works in fractions of a day
You are working in fraction (NOT percentages) of an hour
With 0.5 in A1, the formula =A1/24 in B1 will display 0:30 when formatted
with h:mm
If you want move than 24 houses, use the format [hh]:mm
best wishes