title: DateDiff to output hours and minutes
body: <p>my code gives TOTAL HOURS in hours, but i am trying to output something like </p>
  
  <pre><code>TotalHours 
    8:36
  </code></pre>
  
  <p>where 8 represents hour part and 36 represents minutes part mean totalHours a person has worked in a single day at office.</p>
  
  <pre><code>with times as (
  SELECT    t1.EmplID
          , t3.EmplName
          , min(t1.RecTime) AS InTime
          , max(t2.RecTime) AS [TimeOut]
          , t1.RecDate AS [DateVisited]
  FROM  AtdRecord t1 
  INNER JOIN 
        AtdRecord t2 
  ON    t1.EmplID = t2.EmplID 
  AND   t1.RecDate = t2.RecDate
  AND   t1.RecTime &lt; t2.RecTime
  inner join 
        HrEmployee t3 
  ON    t3.EmplID = t1.EmplID 
  group by 
            t1.EmplID
          , t3.EmplName
          , t1.RecDate
  )
  SELECT    EmplID
          , EmplName
          , InTime
          , [TimeOut]
          , [DateVisited]
          , DATEDIFF(Hour,InTime, [TimeOut]) TotalHours
  from times
  Order By EmplID, DateVisited 
  </code></pre>