How to convert number of minutes to hh:mm format in SQL Server

HI ALL,

I have a select query that has DURATION column to calculate number of Minutes . I want to convert those minutes to hh:mm format.

Duration has values like 60, 120,150

For example: 510 becomes 08:3 hours

i have tried below query but am not getting the exact value.

select ISNULL(CONVERT(VARCHAR,CONVERT(INT,510)/60)+':'+ RIGHT('0'+CONVERT(VARCHAR,CONVERT(INT,510)%60),2),0) AS TotalHour

my expected out put is: 8:3

please guide me were i made mistake.

thanks to all.

regards, stellus