G Guest Mar 3, 2005 #1 I would like to convert fractional hours into hours and minutes. For example, 1.47 hours is 1 hour 28 minutes or 01:28:00.
I would like to convert fractional hours into hours and minutes. For example, 1.47 hours is 1 hour 28 minutes or 01:28:00.
R Ron Rosenfeld Mar 3, 2005 #2 On Wed, 2 Mar 2005 17:17:05 -0800, "Speck Teck" <Speck I would like to convert fractional hours into hours and minutes. For example, 1.47 hours is 1 hour 28 minutes or 01:28:00. Click to expand... =1.47/24 and format as [h]:mm:ss But 1.47 hours is really 1 hour 28 minutes and 12 seconds If what you want is rounded to the nearest minute, then the formula would be: =ROUND(1.47/24*1440,0)/1440 --ron
On Wed, 2 Mar 2005 17:17:05 -0800, "Speck Teck" <Speck I would like to convert fractional hours into hours and minutes. For example, 1.47 hours is 1 hour 28 minutes or 01:28:00. Click to expand... =1.47/24 and format as [h]:mm:ss But 1.47 hours is really 1 hour 28 minutes and 12 seconds If what you want is rounded to the nearest minute, then the formula would be: =ROUND(1.47/24*1440,0)/1440 --ron
G Guest Mar 3, 2005 #3 Thanks, Ron, that did the trick! Ron Rosenfeld said: On Wed, 2 Mar 2005 17:17:05 -0800, "Speck Teck" <Speck I would like to convert fractional hours into hours and minutes. For example, 1.47 hours is 1 hour 28 minutes or 01:28:00. Click to expand... =1.47/24 and format as [h]:mm:ss But 1.47 hours is really 1 hour 28 minutes and 12 seconds If what you want is rounded to the nearest minute, then the formula would be: =ROUND(1.47/24*1440,0)/1440 --ron Click to expand...
Thanks, Ron, that did the trick! Ron Rosenfeld said: On Wed, 2 Mar 2005 17:17:05 -0800, "Speck Teck" <Speck I would like to convert fractional hours into hours and minutes. For example, 1.47 hours is 1 hour 28 minutes or 01:28:00. Click to expand... =1.47/24 and format as [h]:mm:ss But 1.47 hours is really 1 hour 28 minutes and 12 seconds If what you want is rounded to the nearest minute, then the formula would be: =ROUND(1.47/24*1440,0)/1440 --ron Click to expand...
R Ron Rosenfeld Mar 4, 2005 #4 Thanks, Ron, that did the trick! Click to expand... You're welcome --ron
