Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.)..
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. |
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();