Never Mind i figured out

select

(CONVERT(varchar(6), DATEDIFF(second, minibgtime, maxendtime)/3600) + ':' +

RIGHT('0' + CONVERT(varchar(2), (DATEDIFF(second, minibgtime, maxendtime) % 3600) / 60), 2) + ':' +

RIGHT('0' + CONVERT(varchar(2), DATEDIFF(second, minibgtime, maxendtime) % 60), 2)) as Total_Time

from tablename

Thankyou.

--

Sam.