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: http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=524566

Hi!

A1 = 66.5
B1 = formula

=A1/1440

Format B1 as h:mm

Returns: 1:06

Biff

"Anita" wrote in message
...
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