HOUR
function HOUR(arg1: number = null): number | string | booleanDescription
Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.)..
Parameters
- arg1
numberdefault: null 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
number | string | booleanTry It
const oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.HOUR("4:17 pm");
oWorksheet.GetRange("C1").SetValue(ans);