title: Excel - Rounding Date and Time - Up or Down to the Hour
body: <p>I need to round date and time up and down to the hour in Excel.</p>
  
  <p>The MROUND formula only does it to the nearest hour, but in the case of 10/05/2016 09:43 I want it to be rounded down to 10/05/2016 9:00 and in some cases I want to round up too.</p>
  
  <p>It's essential that they stay in the format dd/mm/yyyy hh:mm:ss</p>