HOUR() converts to an hour : HOUR « Date Time functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Date Time functions
  3. HOUR
Input the formula: =HOUR("3:30:30 AM"). Press Enter to get the result.
15.6.HOUR
15.6.1.HOUR() converts to an hour
15.6.2.=HOUR("15:30")