TIME Function – Google Sheets

The TIME function takes three numbers and converts them to a time with hours, minutes, and seconds. You could be working with large tables with separate columns for the hour, minute, and second. The TIME function will combine the three columns into one value.

Furthermore, if you want to use a time in a formula instead of referencing a cell, you can use this function or surround the date/time value with quotes. Formulas do not understand times typed directly into a formula.

Furthermore, if you want to use a time in a formula instead of referencing a cell with a date value, you need to use this function or surround the date value with quotes. Formulas do not understand times typed directly into a formula.

If the result of the formula is not formatted correctly, use the custom formatting options found in the menus.

Custom Formatting Menu
Find the Custom Formatting Options
Custom Date and Time Formats
Choose the Desired Format

Adjust the formatting using the box to the left of the green Apply button until you get what you are looking for.

Syntax

=TIME(hour,minute,second)

hour – The number that represents the hour (0-23).

minute – A number that represents the minute (0-59).

second – The number that represents the second (0-59).

Related Functions

DATE – Similar to this function, the DATE takes three numbers and converts them to a date.

MINUTE – Extracts the minute

HOUR – Extracts the hour

SECOND – Extracts the second

Errors

#VALUE! – The inputs aren’t a valid time, such as “The other day” or “Yester-yester-day”.

Examples

Examples of the TIME Function

Live Examples in Sheets

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

Leave a Comment