software

I have a spreadsheet and in one column in says 66.5 - that's the time it
takes me to run x amount of miles. I did a formula to divide that answer by
60 because I want to show the answer in hours and minutes and it comes out as
1.11. I gather the .11 is part of an hour but how do I display it as 1 hour
6 minutes?

Thanks v. much

If your time is in A1 use the following =A1/1440 and format as h:mm--
intruder9
------------------------------------------------------------------------
intruder9's Profile: www.excelforum.com/member.php...oamp;userid=30107
View this thread: www.excelforum.com/showthread...hreadid=524566Hi!

A1 = 66.5
B1 = formula

=A1/1440

Format B1 as h:mm

Returns: 1:06

Biff

quot;Anitaquot; gt; wrote in message
...
gt;I have a spreadsheet and in one column in says 66.5 - that's the time it
gt; takes me to run x amount of miles. I did a formula to divide that answer
gt; by
gt; 60 because I want to show the answer in hours and minutes and it comes out
gt; as
gt; 1.11. I gather the .11 is part of an hour but how do I display it as 1
gt; hour
gt; 6 minutes?
gt;
gt; Thanks v. much
gt;
gt;