Date Time Functions MSOfficeExcel 2007 Tutorial

  1. Home
  2. MSOfficeExcel 2007 Tutorial
  3. Date Time Functions
  4. To round a time to the nearest 30 minutes, change 0 25 to 0 5
Input the formula: =ROUND(A1*24/0.5,0)*(0.5/24)