TIME function

Microsoft Office ShapeSheet

TIME function

See also

Returns the time represented by hour, minute, and second.

Syntax

TIME(hour,minute,second)

Example 1

TIME(15,30,30)

Returns the value representing 3:30:30 PM.

Example 2

FORMAT(TIME(15,30,30),"HH:mm")

Returns the value representing 15:30.

Example 3

TIME(15,30,30) + 8 eh.

Returns the value representing 11:30:30 PM.