Converting a Decimal HourDate: 11/22/2001 at 06:50:59 From: Steve Cowle Subject: Converting a decimal hour How do I convert 1.7 hours into hours, min, sec? Is there a standard formula I can use? I would like to put this into an Excel spreadsheet. Date: 11/22/2001 at 08:21:26 From: Doctor Jerry Subject: Re: Converting a decimal hour Hi Steve, You can use the "Floor" function in Excel. Put the letters r, h, r, m, and s in cells A1, A2, A3, A4, and A5. These stand for the original time (t), the hours (h), a remainder (r), the minutes (m), and the seconds (s). These are just to help remember what is where. In B1 put the time you want converted. Try 1.82. In B2 put =FLOOR(B1,1) In B3 put =(B1-B2)*60 In B4 put =FLOOR(B3,1) In B5 put =(B3-B4)*60 The result is that 1.82 is converted to 1 hour, 49 minutes, and 12 seconds. If you put 1.877 in for t (in B1), you'll get 1 hour, 52 minutes, and 37.2 seconds. - Doctor Jerry, The Math Forum http://mathforum.org/dr.math/ |
Search the Dr. Math Library: |
[Privacy Policy] [Terms of Use]
Ask Dr. Math^{TM}
© 1994-2013 The Math Forum
http://mathforum.org/dr.math/