Date Time Functions MSOfficeExcel 2007 Tutorial

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