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

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?

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

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.

--
Hth

Kassie Kasselman
Change xxx to hotmail


"Nush" wrote:

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?

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

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Nush" wrote in message
...
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?