excel formula

V

vdmbqb

I need a formula that will return in hours and minutes. For instance, the
number in A2 is 1.75 and I need a formula in B2 that will convert the number
in A2 to 1:45. Any help will be appreciated.

Thanks in advance.
 
P

Pete_UK

Put this in B2:

=A2 / 24

and use a custom format on the cell of [h]:mm

Hope this helps.

Pete
 
Top