Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

Round the time in cell A1 to the nearest minute

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