How to convert decimal minutes to hours:minutes in SQL Server

Question

I would like to know how do you convert minutes that are >=60 to hours for example 0.70 to 1:10

Thanks in advance.

Answer 1

DECLARE  @hours time = '00:00'
SELECT DATEADD(minute,70,@hours)