Google スプレッドシート関数

HOUR

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.

What does the function return if the serial number is a date?

If the date does not include a time component, it returns 0.