TRY NEW VERSION

HOUR

HOUR(arg1) → { number | string | boolean }

Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.)..

Parameters:

Name Type Description
arg1 number

Is a number in the date-time code used by Microsoft Excel, or text in time format, such as 16:48:00 or 4:48:00 PM.

Returns:

Type
number | string | boolean

Example

Copy code
builder.CreateFile("xlsx");

const oWorksheet = Api.GetActiveSheet();

var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.HOUR("4:17 pm"); 

oWorksheet.GetRange("C1").SetValue(ans);

builder.SaveFile("xlsx", "HOUR.xlsx");
builder.CloseFile();

Resulting document