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






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")