Are you looking for this
DECLARE @TABLE AS TABLE (ID INT IDENTITY(1,1),Vehical VARCHAR(50),StartTime DATETIME, EndTime DATETIME)
INSERT INTO @TABLE (Vehical,StartTime,ENDTIME) VALUES('Maruti SX4','2017-04-25 11:29:00','2017-04-25 15:00:36')
INSERT INTO @TABLE (Vehical,StartTime,ENDTIME) VALUES('Honda City','2017-04-26 12:29:36','2017-04-26 15:00:36')
SELECT ID,Vehical,CONVERT(VARCHAR(10),DATEDIFF(HOUR,StartTime,EndTime)) +' HOURS '
+CONVERT(VARCHAR(10),DATEDIFF(MINUTE,StartTime,EndTime)% 60) + ' MINUTES AND '
+CONVERT(VARCHAR(10),DATEDIFF(SECOND,StartTime,EndTime)% 60) +' SECONDS '
AS 'Total Time'
FROM @TABLE
| ID |
Vehical |
Total Time |
| 1 |
Maruti SX4 |
4 HOURS 31 MINUTES AND 36 SECONDS |
| 2 |
Honda City |
3 HOURS 31 MINUTES AND 0 SECONDS |
