title: SQL rounding time to nearest 30 minutes
body: <p>I am using this SQL Query:</p>
  
  <pre><code>SELECT ROUND((hours*60+minutes)/30) from table 
  </code></pre>
  
  <p>which calculates the number 30 minutes segments</p>
  
  <p>if i have 2 hours, 10 minutes this is returning <code>30_minute_segments = '4'</code> however i would like it to show 5 as the <code>10 minutes</code> should count as 30 minutes.</p>
  
  <p>how can i do this?</p>