Returns the serial number of a particular time. The serial number returned by TIME is a decimal fraction ranging from 0 to 0.99999999, representing the times from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.).
Hour is a number from 0 (zero) to 23 representing the hour.
Minute is a number from 0 to 59 representing the minute.
Second is a number from 0 to 59 representing the second.
Microsoft Excel for Windows and Microsoft Excel for the Macintosh use different date systems as their default. For more information about date systems and serial numbers, see NOW.
TIME(12, 0, 0) equals the serial number 0.5, which is equivalent to 12:00:00 P.M.
TIME(16, 48, 10) equals the serial number 0.700115741, which is equivalent to 4:48:10 P.M.
TEXT(TIME(23, 18, 14), "h:mm:ss AM/PM") equals "11:18:14 PM"