TIME function

TIME(hour, minute, second) TIME(hour; minute; second)

hour — Number or { Number }

The hour (0 through 23).

minute — Number or { Number }

The minute (0 through 59).

second — Number or { Number }

The second (0 through 59).

Returns — Number or { Number }

A sequential serial number representing the given hour, minute and second.

Returns a sequential serial number representing the given hour, minute and second.

The value returned from this function can be set as the initial value displayed by a date and time field.

Examples

TIME(1, 25, 2)TIME(1; 25; 2)

Returns a sequential serial number representing 1:25:02 (1:25 AM).

TIME({ 1, 2 }, 25, 2)TIME({ 1; 2 }; 25; 2)

Returns an array of sequential serial numbers representing 1:25:02 (1:25 AM) and 02:25:02 (2:25 AM).

TIME({ 1, 2 }, { 25, 51 }, 2)TIME({ 1; 2 }; { 25; 51 }; 2)

Returns an array of sequential serial numbers representing 1:25:02 (1:25 AM) and 02:51:02 (2:51 AM).

FORMATTIME(TIME(15, 30, 0))FORMATTIME(TIME(15; 30; 0))

Returns "3:30 PM" if the language of the app is set to US English.