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