G
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?
best way to convert that to time i.e 2 Hrs. 45 Minutes?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Paul Corrado
In Excel 1 day = 24 hours so if you have the time in hours divide by 24
PC
PC
D
Dan E
A formula
D
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
=TIME(QUOTIENT(A1,1),MOD(A1,1)*60,0)
I apologize for the previous message, it just sent itself???
Dan E
P
Peo Sjoblom
Divide by 24 and format cell as time hh:mm or something similar
G
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
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
P
Peo Sjoblom
Why don't you try the posted solutions?
The answer is still divide by 24..
The answer is still divide by 24..