TIME
Also known as · Time Functions
Builds a time value from three numbers: TIME(hour, minute, second), so TIME(9,45,22) gives 0.4065... of a day. Use it when the three parts are in separate cells or typed in the formula.
When to use
Do not confuse it with TIMEVALUE: TIME takes three numbers, TIMEVALUE takes one text string. Format the result with a Time Format to read it as a clock time.
See Lec 05.