excel formula
 

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

excel formula
 

Put this in B2:

=A2 / 24

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

Hope this helps.

Pete

On Sep 24, 1:25*am, vdmbqb wrote:
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.
--
bob