mysql minutes to hours and minutes

You should look up FLOOR() function, and simple math. You need something like

CONCAT(FLOOR(minutes/60),'h ',MOD(minutes,60),'m') 

CONCAT(FLOOR(minutes/60),':',LPAD(MOD(minutes,60),2,'0'))

a variation on Damir Kasipovic's code: this converts 62 minutes to '1:02'