HomeExcel Functions ► Excel TIME Function

Syntax For Excel TIME Function

What is the use of Excel TIME Function?

Use Excel TIME Function to create a time value by the specifying hour, minute & second as a number. In simple words, you can create a valid time value by using a number for hours, minutes & seconds.

Syntax for Excel TIME Function

TIME(hour,minute,second)

hour A number to use as an hour value.

minute A number to use as a minute value.

second A number to use as a second value.

More Information on Excel TIME Function

  • Excel stores date & time in a serial number. In a valid date, serial number integer represents date & decimal part represents time.
  • You can also directly enter arguments into the function.
  • It will return the same result if you use double quotation marks or not.
  • When initially create a time value with this function it will give you time in 12-hour format using AM/PM with it but  you can change it by changing time format.

Examples to understand Excel TIME Function

Examples For Excel TIME Function

In above example, I have used different arguments for your better understanding.

  1. Date return by the function in 12-hour format.
  2. If you use zero for the hour value it will give you time from starting hour of a day.
  3. When you specify a negative number it will deduct that value from the previous hour, minute or second.
  4. Time function returns a decimal number which represents a particular time in excel.

You can also use time function with other function to create some dynamic functions.

Download Sample File

Download Sample File To Learn Excel TIME Function

More Tips Related With Excel TIME Function

Conclusion

Use Excel Time Function to create a valid serial number which represents time as excel’s date & time system. Learn more about TIME from here.

Related Function

Date | TimeValue

Blog | Excel Functions