excel formula

[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.

 

[Pete_UK]

Put this in B2:

=A2 / 24

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

Hope this helps.

Pete