title: MS SQL server 2005: Checking time In/Out attendance (time shift work)
body: <p>I have the following table in my Time Attendance Database each row </p>
  
  <pre>
  ID_Emp  FullName    DateCheck   TimeIO
  11  RONA    11/05/2014  8:16
  11  RONA    11/05/2014  13:35
  11  RONA    11/05/2014  17:23
  11  RONA    11/05/2014  21:09
  12  Elizabe 11/05/2014  14:06
  12  Elizabe 11/05/2014  22:39
  13  Jimmy   11/05/2014  8:00
  13  Jimmy   11/05/2014  12:00
  
  </pre>
  
  <p>OUTPUT  </p>
  
  <pre>
  ID_Emp  FullName    DateCheck   TimeIn  TimeOut Hours
  11  RONA    11/05/2014  8:16    13:35   5:19
  11  RONA    11/05/2014  17:23   21:09   3:46
  12  Elizabe 11/05/2014  14:06   22:39   8:33
  13  Jimmy   11/05/2014  8:00    17:12   9:12                
  </pre>