help showing hours and minutes

[ghynes]

i need to show cells in hours and minutes. for example.
i have cells with 60, 62, 80, 90 as numbers and i need to show equivalent cells in hours and minutes so i need the cells beside it to show 1 hour, 1 hour 2 minutes, 1 hour 20 minutes, 1 hour 30 minutes... and so forth.

can anyone assist?

[Dav]

put the formula next to it if it is in a2
=a2/60/24 you have to make it a fraction of a day hence divide by minutes and hours

format custom as

[h] "hours" m "minutes"

Regards

Dav