TIME (Hour, Minute, Second) TIME (Hour; Minute; Second)
Hour
Number Number
The hour (0 through 23).
Minute
Number Number
The minute (0 through 59).
Second
Number Number
The second (0 through 59).
Returns
Temporal Temporal
A temporal value representing the given hour, minute and second.
Returns a temporal value representing the given hour, minute and second.
Examples
TIME (1, 25, 2)
TIME (1; 25; 2)
Returns a temporal value representing 1:25:02 (1:25 AM).
TIME ({ 1, 2 }, 25, 2)
TIME ({ 1; 2 }; 25; 2)
Returns an array of temporal values 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 temporal values representing 1:25:02 (1:25 AM) and 02:51:02 (2:51 AM).
FORMAT.TIME ( TIME (15, 30, 0))
FORMAT.TIME ( TIME (15; 30; 0))
Returns "3:30 PM" if the configured locale is US English.