Google Sheets - HOUR function
HOUR function returns the hour component of a time. Syntax HOUR(time) Example Notes HOUR function uses the 24-hour system. Therefore, HOUR("5:03:24 pm") returns 17, not 5. The seconds component in a time is optional. Therefore, 4:32 AM is equivalent to 4:32:00 AM. Actually, the minutes component is also optional. If you enter 4 am, it will be converted 4:00 am automatically.