HOUR Function
This function is used to get Hour from the given time in 24 hours format.
Syntax: HOUR(serial_number)
Example: =HOUR("4:00 PM")
Result: 16
Example: =HOUR("11:30 AM")
Result: 11
Also works with NOW() Function
Example: =HOUR(NOW())
Hour of System time will be displayed
This function is used to get Hour from the given time in 24 hours format.
Syntax: HOUR(serial_number)
Example: =HOUR("4:00 PM")
Result: 16
Example: =HOUR("11:30 AM")
Result: 11
Also works with NOW() Function
Example: =HOUR(NOW())
Hour of System time will be displayed
No comments:
Post a Comment