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.
Adjust the formatting using the box to the left of the green Apply button until you get what you are looking for.
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).
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
#VALUE! – The inputs aren’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 function shown above that you can study and use anywhere you would like.