## How to use the TIME function

*Article last updated on June 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.

Highlight specific time ranges in a weekly schedule

In a previous post I created a simple weekly schedule with dynamic dates. In this post I am going to […]

I have built a sheet to track time at work. It is very simple, there are 13 sheets, one for each […]

Calculate time between time zones

The worksheet below lets you enter cities and their time difference. Excel calculates the corresponding local times in E5:E8. Press F9 to […]

Count entries between date and time criteria

Question: My issue is that I get the date in this format: 7/23/2011 7:00:00 AM I am trying to count […]

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 […]

Find empty hours in a weekly schedule

In this post, I have created som random time ranges. We are going to use these time ranges to extract […]

Column C contains both date and time, to calculate the average of only time we need to extract the hours, minutes […]

### Functions in 'Date and Time'

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

The DATE function returns a number that acts as a date in the Excel environment. The image above shows you […]

How to use the DATEDIF function

The DATEDIF function returns the number of days, months, or years between two dates. The DATEDIF function exists in order to […]

How to use the DATEVALUE function

The DATEVALUE function returns an Excel date value (serial number) based on a date stored as text. Excel Function Syntax […]

The DAY function extracts the day as a number from an Excel date. Formula in cell C3: =DAY(B3) Excel Function […]

The DATE function calculates the number of days between two dates. Formula in cell D3: =DAYS(B3,C3) Excel Function Syntax DAYS(end_date, […]

The EDATE function returns a date determined by a start date and a number representing how many months. Use EDATE […]

How to use the EOMONTH function

The EOMONTH function returns an Excel date for the last day of a given month using a number and a start […]

Returns an integer representing the hour of an Excel time value. The returning number is ranging from 0 (12:00 A.M.) […]

How to use the MINUTE function

Returns a whole number representing the minute based on an Excel time value. The returned number is ranging from 0 […]

Extracts the month as a number from an Excel date. Formula in cell C3: =MONTH(B3) Excel Function Syntax MONTH(serial_number) Arguments […]

How to use the NETWORKDAYS function

The NETWORKDAYS function returns the number of working days between two dates, excluding weekends. It also allows you to ignore […]

The NOW function returns the current date and time. Formula in cell B3: =NOW() Excel Function Syntax NOW() Arguments The […]

How to use the SECOND function

Returns an integer representing the second based on an Excel time value. The returning number is ranging from 0 to […]

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 […]

How to use the TIMEVALUE function

The TIMEVALUE function returns a decimal number based on a text string. Excel uses decimal numbers between 0 and 0.99988426 […]

The TODAY function returns the Excel date (serial number) of the current date. Warning! This function is volatile meaning it […]

How to use the WEEKDAY function

Converts a date to a weekday number from 1 to 7. Formula in cell D3: =WEEKDAY(B3) Excel Function Syntax WEEKDAY(serial_number,[return_type]) […]

The YEAR function converts a date to a number representing the year in the date. The number is between 1900 […]

## How to comment

How to add a formula to your comment<code>Insert your formula here.</code>

Convert less than and larger than signsUse html character entities instead of less than and larger than signs.

< becomes < and > becomes >

How to add VBA code to your comment[vb 1="vbnet" language=","]

Put your VBA code here.

[/vb]

How to add a picture to your comment:Upload picture to postimage.org or imgur

Use the img tag, like this: <img src="Insert pic link here">

Contact OscarYou can contact me through this contact form