Converting Numbers to Time

[Guest]

I have a cell that shows 2.75 hours per widget. What the
best way to convert that to time i.e 2 Hrs. 45 Minutes?

 

[Paul Corrado]

In Excel 1 day = 24 hours so if you have the time in hours divide by 24

PC

 

[Dan E]

A formula

 

[Dan E]

A formula
=TIME(QUOTIENT(A1,1),MOD(A1,1)*60,0)

I apologize for the previous message, it just sent itself???

Dan E

 

[Peo Sjoblom]

Divide by 24 and format cell as time hh:mm or something similar

 

[Guest]

I wasn't clear. The cell is a number only that shows
2.75. From a timevalue this would equate to 2 hours and
45 minutes. Is there a formula that would convert the
numbers into time (like 2.38 for example, how many minutes
is .38?)

Thanks

 

[Peo Sjoblom]

Why don't you try the posted solutions?
The answer is still divide by 24..