Converting Minutes into Hours and Minutes using a Formula

[Onjslnjps]

Can anybody please assist me with creating a formula for converting time data that has been created in an excel spreadsheet in minutes i.e. 516 minutes which I need to turn into Hours and Minutes i.e. 08:36
I am not experienced using Formulas, apologies if this question has been posted before, I did use the search facility to look for threads, but could not find anything related

Many Thanks

 

[VoG]

Try

=A1/1440

Format as Time.

 

[JazzSP8]

Hi

Divide your cell by 1440, so if 516 is in A1 then;

=A1/1440

Then you need to format your cell as [h]:mm

HTH