Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

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)