1Small change like this can be done
2
3 SELECT EmplID
4 , EmplName
5 , InTime
6 , [TimeOut]
7 , [DateVisited]
8 , CASE WHEN minpart=0
9 THEN CAST(hourpart as nvarchar(200))+':00'
10 ELSE CAST((hourpart-1) as nvarchar(200))+':'+ CAST(minpart as nvarchar(200))END as 'total time'
11 FROM
12 (
13 SELECT EmplID, EmplName, InTime, [TimeOut], [DateVisited],
14 DATEDIFF(Hour,InTime, [TimeOut]) as hourpart,
15 DATEDIFF(minute,InTime, [TimeOut])%60 as minpart
16 from times) source