excel formula

  • Thread starter Thread starter vdmbqb
  • Start date Start date
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.
 
Put this in B2:

=A2 / 24

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

Hope this helps.

Pete
 
Back
Top