Excel TIME Function returns the valid time with hours, minutes, and seconds value.

TIME Function: A Brief

The Excel TIME Function is used to create or return a valid Excel time value from individual hour, minute, and second values. This function is extremely helpful when you’re working with data that stores time in parts and you need to convert it into a proper Excel time format.

Objective

TIME Function: A Syntax

=TIME(hour, minute, second) // Returns a proper Excel Time Value.

The TIME Function will return the #NUM! error if any of the inputs are invalid or text or exceed the numerical input (32767) supported by Excel.

Note: The Excel TIME function will reset the time values if hour, minutes, second values exceeds the expected numerical inputs. For example: =TIME(38,0,0) // The TIME function returns the value as 14:00:00 as the output.

Function Compatibility:

The Excel TIME Function was introduced in the very early versions of Excel. This function is supported by every modern version of Excel, including Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, and Microsoft 365.

Time Format in TIME Function:

The TIME function returns a valid time as a decimal number, but how Excel displays that result depends on the number format applied. Excel can show the result in different ways, such as AM/PM format, 24-hour format (like 13:45:00), or simply as a regular decimal number.

You can compare how these formats look by applying different number formats to separate cells or columns, just like in an example where columns E, F use different time formats.

Time Function with custom time formatting the output values.

Basic Examples of Using the TIME Function:

Examples Explanation:

Using TIME Functions With Other Nested Functions:

That’s it. The article was originally published on: How to use Excel TIME Function?

Vigneshwaran Vijayakumar.