HOUR
Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).
Syntax
expression.HOUR(arg1);
expression
- A variable that represents a ApiWorksheetFunction class.
Parameters
Name | Required/Optional | Data type | Default | Description |
---|---|---|---|---|
arg1 | Required | ApiRange | ApiName | number | string | A number in the date-time code, or text in the time format, such as "16:48:00" or "4:48:00 PM", or a result of other formulas or functions. |
Returns
number
Example
- Code
- Result
const worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
let ans = func.HOUR("4:17 pm");
worksheet.GetRange("C1").SetValue(ans);