Returns the hour of a time value as a number from 0 to 23.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
HOUR(serial_number)The HOUR function extracts the hour component from a given time value. The result is an integer ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.).
=HOUR("15:30")결과: 15
Extracts the hour from the time 3:30 PM.
If the date does not include a time component, it returns 0.