Minutes to Hours and Mins

[Chimp8471]

i have to convert, minutes into hours and minutes,to work out average stops per stoppage. how can i do this please.

i have tried dividing my minute by 60 but then get silly answers:

example

416 minutes divided by 60 = 6.9333333 hours

but really this is 6 hours and 56 mins

how can i get the correct figure .

Andy

 

[KenHigg]

Hint: 60 * .9333333 = 56

Hint 2: int(6.9333333) = 6

 

[raskew]

x = 416
? x \ 60 & " hours " & x mod 60 & " minutes"
6 hours 56 minutes

Bob

 

[namliam]

You want to average times....

OK, take your minutes /60/24 to get to a "Real Time"
?format(416/60/24,"HH:NN:SS")
06:56:00

Problem with this is you cannot go over 23:59:59

Greetz