Returns the hour of a time value as a number from 0 to 23.
Эта функция в Google Таблицах работает так же, как в 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.