## How to use the TIME function

*Article updated on January 17, 2018*

The TIME function returns a decimal value between 0 (zero) representing 12:00:00 AM and 0.99988426 representing 11:59:59 P.M.

Formula in cell D3:

### Excel Function Syntax

TIME(*hour*, *minute*, *second*)

### Arguments

hour |
Required. A number between 0 and 32767 that represents the hour. |

minute |
Required. A number between 0 and 32767 that represents the minute. |

second |
Required. A number between 0 and 32767 that represents the second. |

### Comment

An hour value greater than 23 will be divided by 24 and the remaining hours will be returned by the function. See row 5 in the picture above.

A minute value greater than 59 will be divided by 60 and the remaining minutes will be returned by the function. See row 6 in the picture above.

A "second" value greater than 59 will be divided by 60 and the remaining seconds will be returned by the function. See row 7 in the picture above.

### Articles with the 'TIME' Function

The following 7 articles have formulas that contain the TIME function.

How to create random numbers, text strings, dates and time values

In excel the RAND() function returns a number greater than or equal to 0 (zero) and less than 1. Combining […]### Functions in 'Date and Time'

The TIME function function is one of many functions in the 'Date and Time' category.