Manuals/calci/HOUR

HOUR (Value)

• where $Value$ is the time to find the hour value.

HOUR() Converts a serial number to an hour.

Description

HOUR(Value)

For Example,

HOUR("3:25 AM") returns 3

• Argument $Value$ can be time in the form of text or as a result of any other functions.
• Argument $Value$ should be enclosed in quotes e.g. "11:00 AM".
• If $Value$ 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

• MINUTE
• SECOND

References

• Hour

• List of Main Z Functions

• Z3 home