TIME Function

The TIME function is one of the date and time functions. It is used to add a particular time in the selected format (hh:mm tt by default).

Syntax

TIME(hour, minute, second)

The TIME function has the following arguments:

Argument Description
hour A number from 0 to 23.
minute A number from 0 to 59.
second A number from 0 to 59.

Notes

How to apply the TIME function.

Examples

The figure below displays the result returned by the TIME function.

TIME Function