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.

Appears in

No references yet.