title: Round Excel Time Difference to Next 15 Minute Interval
body: <p>I have a start time and an End Time in Excel:</p>
  
  <p>Start Time
  9:15 PM</p>
  
  <p>End Time 9:30 PM
  Time Spent 0:15</p>
  
  <p>I'm looking to round up to the next 15 minute increment, and are using the formula:</p>
  
  <p><code>=ROUNDUP(A1*96,0)/96</code></p>
  
  <p>However, this rounds up the example data above from 0:15 to 0:30 (It should stay at 0:15 because it's a quarter hour already)</p>
  
  <p>How to I avoid the rounding if the time difference is ALREADY on a quarter hour?</p>