Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

Round the time in cell A1 to the nearest 15 minutes (quarter of an hour)

Input the formula: =ROUND(A1*24/0.25,0)*(0.25/24)