Returns the hour of a time value as a number from 0 to 23.
Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.
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")Resultat: 15
Extracts the hour from the time 3:30 PM.
If the date does not include a time component, it returns 0.