TIME

Returns a text string for a given time.

Syntax

TIME(hour, minute, second)

Arguments

hour Number for the hour (0-23)
minutes Number for the minute (0-59).
seconds Number for the seconds (0-59).

Example

TIME(8,15,10) returns the text "3:15 PM" when formatted as a time.