TIME function
Hour
The hour (0 through 23).
Minute
The minute (0 through 59).
Second
The second (0 through 59).
Returns
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
Returns a sequential serial number representing 1:25:02 (1:25 AM).
Returns an array of sequential serial numbers representing 1:25:02 (1:25 AM) and 02:25:02 (2:25 AM).
Returns an array of sequential serial numbers representing 1:25:02 (1:25 AM) and 02:51:02 (2:51 AM).
Returns "3:30 PM" if the language of the app is set to US English.