Difference between revisions of "Manuals/calci/HOUR"

From ZCubes Wiki
Jump to navigation Jump to search
Line 43: Line 43:
 
| class="sshl_f" |22
 
| class="sshl_f" |22
 
|}
 
|}
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|DLno3b-Xsmo|280|center|HOUR}}
  
 
== See Also ==
 
== See Also ==

Revision as of 12:16, 25 April 2015

HOUR(sn)

  • where is the time to find the hour value.

HOUR() returns the hour value from the input time.

Description

HOUR(sn)

For Example,

HOUR("3:25 AM") returns 3

  • Argument can be time in the form of text or as a result of any other functions.
  • Argument should be enclosed in quotes e.g. "11:00 AM".
  • If is invalid, Calci returns an #ERROR message.
  • The output hour value is the value in integers considering a 24 hour clock. It ranges from '0' for 12:00:00 AM to '23' for 11:00:00 PM.

Examples

Function Output
HOUR("12:00:00 AM") 0
HOUR("4:50 PM") 16
HOUR("11:30") 11
HOUR("10:00:00 PM") 22

Related Videos

HOUR

See Also

References