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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top