Manuals/calci/HOUR
Jump to navigation
Jump to search
HOUR (Value)
- where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Value} can be time in the form of text or as a result of any other functions.
- Argument Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Value} should be enclosed in quotes e.g. "11:00 AM".
- If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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
See Also
References