Mega Code Archive
Categories
/
MSOfficeExcel 2007 Tutorial
/
Date Time Functions
Round the time in cell A1 to the nearest hour
Input the formula: =ROUND(A1*24,0)/24