DECLARE @time INT
SET @time = 7382
SELECT 
      @time / 3600 AS Stunden
     , (@time / 60)% 60 AS Minuten
     , @time % 60 AS Sekunden

Stunden     Minuten     Sekunden    
----------- ----------- ----------- 
2           3           2

(1 row(s) affected)