title: Calculate TIME IN ACCESS more than 24hours
body: <p>I don't know if it's the right place to ask my question but I can't find anything else related in  the Website.</p>
  
  <p>I have an Access database that creates reports.</p>
  
  <p>I have create queries and I want to calculate time more than 24 hours. 
  I have use function</p>
  
  <pre><code>TimeSerial((Sum(Minute(Table1.Field1)+Hour(Table1.Field1)*60)\60),(Sum(Minute(Table1.Field1)+Hour(Table1.Field1)*60) Mod 60),0) AS test
  </code></pre>
  
  <p>but the problem is that when the hours is more than 24 start from the beginning.</p>
  
  <p>For example if I have a sum of 27:30 hours the result from my query will be 
  3:30.</p>