How can I convert fractional hours to minutes?

G

Guest

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

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

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...
 

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

How do I process hours greater than 24 2
How do I convert hours to days? 2
CONVERT HOURS AND MINUTES TO INT 3
Convert minutes into hours and minutes 6
I have 3053 minutes and I want to convert to hours and minutes 2
Formatting cells with time 3
i want to convert decimals into time format 3
pasting time from html 12

Top