=HOUR("15:30") : HOUR « Date Time functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =HOUR("15:30"). Press Enter to get the result.
15.6.HOUR
15.6.1.HOUR() converts to an hour
15.6.2.=HOUR("15:30")