Count time difference in hh:mm:ss between two Date in SQL Server

Hi Ruben12345,

Refer the below sample query.

DECLARE @TABLEA AS TABLE (ID INT IDENTITY(1,1),Vehicle VARCHAR(50),Start DATETIME, [End] DATETIME)
INSERT INTO @TABLEA (Vehicle,Start,[End]) VALUES('Maruti SX4','2017-04-25 11:29:00','2017-04-25 15:00:36')
INSERT INTO @TABLEA (Vehicle,Start,[End]) VALUES('Honda City','2017-04-26 12:29:36','2017-04-26 15:00:36')

SELECT ID,Vehicle,CONVERT(VARCHAR(5),DATEDIFF(S, Start, [End])/3600)+' hours '
+CONVERT(VARCHAR(5),DATEDIFF(S, Start, [End])%3600/60)+' minutes '
+CONVERT(VARCHAR(5),(DATEDIFF(S, Start, [End])%60))+' seconds' AS [TIME] FROM @TABLEA

Output