title: Trying to calculate the difference in punch-in/punch-out times without rounding
body: <p>I need to get a total of hours worked but my result always ends up in a rounded number.  I need to show the real hours worked to two decimal places.  Here is my code thus far:</p>
  
  <pre><code>CAST((datediff(mi,CONVERT(datetime,p.Punchin,114),CONVERT(datetime,p.Punchout,114)) - datediff(mi,CONVERT(datetime,p.Lunch_in,114),CONVERT(datetime,p.Lunch_out,114)))/60 AS decimal (12,2)) AS "Hours Worked"
  </code></pre>
  
  <p>Not sure where I am going wrong but assistance is greatly appreciated.</p>