How to convert a number into hours in Google Sheets

Use convert function to convert a numeric value to a different unit of measure

=CONVERT(A1; "mn"; "hr")

Documentation

Here is a function that converts minutes in hour:minutes,

=if( A1 = 0 ; "" ; concatenate( quotient( A1 ; 60 ) ; ":" ;MOD(A1  ; 60) ))

62 --> 1:2

Related