TIME
function TIME(
arg1: number = null,
arg2: number = null,
arg3: number = null,
): number | string | booleanDescription
Converts hours, minutes and seconds given as numbers to a serial number, formatted with a time format.
Parameters
- arg1
numberdefault: null Is a number from 0 to 23 representing the hour.
- arg2
numberdefault: null Is a number from 0 to 59 representing the minute.
- arg3
numberdefault: null Is a number from 0 to 59 representing the second.
Returns
number | string | booleanTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.TIME(23, 4, 39));