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.
On Wed, 2 Mar 2005 17:17:05 -0800, "Speck Teck" <Speck
[email protected]> 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
> [email protected]> 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"
<[email protected]> wrote:
>Thanks, Ron, that did the trick!
You're welcome
--ron
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks