title: round sql integer to nearest hour
body: <p>I have a column formatted as an integer (values ex. 2300, 0040, 2090) with values representing military time.  What would be the easiest way to round these values to the nearest hour?  So, if 2330, would round up to 2400, etc.  I don't want the values converted to date/time.</p>
  
  <p>I'm looking for help in either SQL or Excel.   Thanks.</p>