TIMEΒΆ

Calculates the serial number which corresponds to the time specified by given hours, minutes and seconds

Syntax

=TIME(Hours, Minutes, Seconds)

Arguments

Name

Description

Hours

A number which specifies hours

Minutes

A number which specifies minutes

Seconds

A number which specifies seconds

Return Value

A serial number value which corresponds to specified time.

Example

Function

Result

Comment

=TIME(12, 0, 0)

0.5

The given time value represents 12:00 AM.