Help with calculating time

[Guest]

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

 

[intruder9]

If your time is in A1 use the following =A1/1440 and format as h:m

 

[Biff]

Hi!

A1 = 66.5
B1 = formula

=A1/1440

Format B1 as h:mm

Returns: 1:06

Biff