Ticks into DD:HH:MM

So far i have this  CAST((SUM(sh.WorkedElapsedTicks) / 600000000)/60 AS VARCHAR(8)) + ':' + RIGHT('0' + CAST((SUM(sh.WorkedElapsedTicks) / 600000000) % 60 AS VARCHAR(8)), 2) as TimeSpent  Go to the complete details ...