Converts a provided hour, minute, and second into a time.

How To Use in Sheets

TIME(hour, minute, second)

External Links

Google Sheet: Date & Time Functions that convert

How to use the date and time functions in Google Sheet that convert between the date, month, year, hours, minutes & seconds that we understand and the date numbers that Google Sheet uses.The video also covers functions that convert text strings into Google Sheet's date numbers and another function that calculates the day of the week.

0Better Sheets Tutorials

No videos yet. Stay tuned!