Converting Numbers to Time

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
In Excel 1 day = 24 hours so if you have the time in hours divide by 24

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

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

Dan E
 
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
 
Why don't you try the posted solutions?
The answer is still divide by 24..
 
You must log in or register to reply here.

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

Similar Threads

Subtracting time...again 2
convert decimal numbers to a fraction of an hour for payroll hour 4
How to Convert MBOX to PST Online? 3
Converting time to Minutes 2
HOW TO CONVERT TIME FORMAT IN HOURS TO MINUTES 2
TimeSheet Using 100 Minutes & Rounding to .25 2
Round it off 3
Excel functions 2

Back
Top