TIME

See also A-Z Spreadsheet Function List

Description Returns a serial number for the supplied time.

Syntax TIME(hour, minute, second)

hour is a number from 0 to 23.

minute is a number from 0 to 59.

second is a number from 0 to 59.

See Also HOUR , MINUTE , NOW , SECOND , and TIMEVALUE functions

Examples TIME(12, 26, 24) returns .52

         TIME(1, 43, 34) returns .07