Hour

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.).
Syntax:
HOUR(datetime|utc)
Parameters:
date (DateTime)
 Date with time of the hour we are getting. 
utc(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)
 
 
 
 
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk