Functions

TIME

Creates a time serial number from components

Try it

When to use it

When should I use TIME?

Use TIME to build a time serial number from individual hour, minute, and second components so you can add it to a date serial or compare times programmatically.

Used in

operations

Syntax

TIME(hour,minute,second)

Examples

=TIME(11,40,59) // => 0.4867939814814815
=TIME(0,0,0) // => 0
=TIME(25,0,0) // => 0.04166666666666674

TEXTJOIN

Join values with delimiter, optionally skip empty

TIMEVALUE

Converts a time string to a fractional serial number