**Excel TIME function**

This inbuilt function allows us to create a ‘time’ with individual components containing the hour, minute and second values. This function becomes useful whenever it comes to an assembling a proper or valid time inside another formula.

**Syntax**

`=TIME(hour,min,sec)`

**Argument or Parameter**

**hour**– This represents the hour for the time you would like to create.

**min**– This represents the minute for the time you would like to create.

**sec**– This represents the second for the time you would like to create.

**Note on the usage of the function**

- TIME function also creates a date in a serial number format from the hour, min and sec components that you specify
- Always use valid component values to get a valid time, and once you have a valid time, you can format it in your own way.

**Note on TIME formula examples**

The Excel TIME function can be combined with other functions to perform unique operations. These operations include.

- Add decimal hours or decimal minutes to time by using TIME function (or) by adding hours or minutes divided by 24 times.
- To sum the total amount of time over 30 minutes by using SUMPRODUCT along with TIME function
- Count the time in a given range by using the COUNTIFS function along with TIME function.

**Example**

Let us understand the TIME function from the following example. The example shows different values of hour, minute and second parameters of the TIME function.

*Figure 1. Excel TIME function with negative second value*

*Figure 2. Excel TIME function with the minute value greater than 60*

*Figure 3. Excel TIME function representing a simple hour, minute, second values.*

## Leave a Comment