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.

On Wed, 2 Mar 2005 17:17:05 -0800, "Speck Teck" <Speck
wrote:

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.

=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

Thanks, Ron, that did the trick!

"Ron Rosenfeld" wrote:

On Wed, 2 Mar 2005 17:17:05 -0800, "Speck Teck" <Speck
wrote:

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.

=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 Thu, 3 Mar 2005 14:53:01 -0800, "Speck Teck"
wrote:

Thanks, Ron, that did the trick!

You're welcome

--ron