The TIME function takes three numbers and converts them to a time. The hour is input as 0-24 and therefore therefore you don't need to enter AM/PM.

Syntax

=TIME(hour,minute,second)

hourNumber that represents the hour (0-23).

minuteNumber that represents the minute (0-59).

secondNumber that represents the second (0-59).

Related functions

DATE- In a similar way to the TIME function, DATE takes three numbers and converts them to a date.

Errors

#VALUE!- The inputs are something that isn't a valid time such as "The other day" or "Yester-yester-day".

Examples

 Live examples in Sheets 

Go tothis spreadsheetfor the examples of the TIME function shown above that you can study and use anywhere you would like.