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.
Comments
Post a Comment