Converting Numbers to Hours and Minutes

[BrianFawcett]

I have spreadsheet where I have a column in a number format (###.#) I want to convert this to hours and minutes. For example, I want to display 138.2 as 2:18, or something very similar. Can anyone help me with this? Thanks.

 

[Brianwarnock]

=INT(A1/60 ) & ":" & ROUND(MOD(A1,60),0)

Brian