Convert minutes into hours in SQL

Question

I want to convert 300 minutes into 5 hours. Input is 300 Output should be 05:00

---

Answer 1

Try this:

select convert(varchar(5), dateadd(MINUTE, 300, '1970-01-01'), 108)