Difference between revisions of "Manuals/calci/HOUR"
Jump to navigation
Jump to search
| Line 15: | Line 15: | ||
*Argument <math>sn</math> can be time in the form of text or as a result of any other functions. | *Argument <math>sn</math> can be time in the form of text or as a result of any other functions. | ||
*Argument <math>sn</math> should be enclosed in quotes e.g. "11:00 AM". | *Argument <math>sn</math> should be enclosed in quotes e.g. "11:00 AM". | ||
| − | *If <math>sn</math> is invalid, Calci returns an | + | *If <math>sn</math> 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. | *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. | ||
Revision as of 16:12, 16 December 2013
HOUR(sn)
- where is the time to find the hour value.
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.