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?