To round a time to the nearest 30 minutes, change 0.25 to 0.5 : TIME « Date Time functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Date Time functions
  3. TIME
Input the formula: =ROUND(A1*24/0.5,0)*(0.5/24)








15.12.TIME
15.12.1.TIME(hour,minute,second) returns the serial number of a particular time
15.12.2.Displaying Any TimeDisplaying Any Time
15.12.3.Calculating the Difference between Two TimesCalculating the Difference between Two Times
15.12.4.Add two hours and 30 minutesAdd two hours and 30 minutes
15.12.5.Round the time in cell A1 to the nearest minute:
15.12.6.Round the time in cell A1 to the nearest hour:Round the time in cell A1 to the nearest hour:
15.12.7.Round the time in cell A1 to the nearest 15 minutes (quarter of an hour)
15.12.8.To round a time to the nearest 30 minutes, change 0.25 to 0.5