HOUR - Google Docs Editors Help
Returns the hour component of a specific time, in numeric format. Sample Usage HOUR(TIME(11,40,59)) HOUR(A2) HOUR(40909.0004) HOUR("20:49:59") Syntax HOUR(time)