Navigation:  Formulas and functions > Functions from A to Z > TIME (create time)

Syntax:

TIME(Hour, Minute, Second)

Description:

This returns a serial date value based on the specified Hour, Minute and Second.

Example:

TIME(0, 20, 0) returns 0.01389, the serial date value for the corresponding time. Calculate automatically applies the number format "Date/Time" to it (e.g., 00:20:00 is displayed).

See also:

TIMEVALUE, DATE, DATEVALUE