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(date)
HOUR(date)
Parameters:
date (Date)
Returned type:
Number
examples:
=hour(date(2016,1,1,1,1))
=hour(A1)
=hour(date(2016,1,1,1,1))
=hour(A1)
0 Comments