Description of formula:
Returns the hour of a time value. The hour is given as an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.).
Returns the hour of a time value. The hour is given as an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.).
Syntax:
HOUR(datetime|utc)
HOUR(datetime|utc)
Parameters:
datetime(type: DateTime)
datetime(type: DateTime)
Date with time of the hour we are getting.
utc(type:UTC)
Date with time in UTC format of the hour we are getting.
Returned type:
Number
examples:
=hour(datetime(2016,1,1,1,1))
=hour(A1)
=hour(datetime(2016,1,1,1,1))
=hour(A1)
0 Comments