title: I want Hours,Min, second difference from two datetime
body: <p>I am developing Time management system for employees.</p>
  
  <p>I want the duration how much duration employee come late , or he went early.</p>
  
  <p>i have following structure.</p>
  
  <pre><code>**Attendace**  
  AutoId --uniqueidentifier             
  EMployeeId --uniqueidentifier
  Date   --datetime
  InTime -- varchar(50)
  OutTime -- varchar(50)
  ActualInTime--datetime
  ActualOutTime--datetime
  </code></pre>
  
  <p>I want Late Coming Report ( i.e. who came late in morning after ActualInTime and how much duration in hh:mm:ss ) and also want early going(i.e who went early in the evening before ActualOutTime in duration in format hh:mm:ss )</p>
  
  <p>So can you please help me..???</p>