TIME Function – Google Sheets

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.



hour Number that represents the hour (0-23).

minute Number that represents the minute (0-59).

second Number 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.


#VALUE! – The inputs are something that isn’t a valid time such as “The other day” or “Yester-yester-day”.


 Live examples in Sheets

Go to this spreadsheet for the examples of the TIME function shown above that you can study and use anywhere you would like.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>