Excel TIME Function

HomeExcel FunctionsExcel TIME Function (Example + Sample File)

What is EXCEL TIME FUNCTION

The Excel TIME Function is listed under Microsoft Excel's Time Functions category. It returns a valid time based on the hours, minutes, and seconds you input. In simple words, you need to specify all the components of the time and it will create a time value with it and return in the result.

How to use it

To learn how to use the TIME function in Excel, you need to understand its syntax and arguments: 

Syntax

TIME(hour,minute,second)

Arguments

  • hour: The number to use like an hour value.
  • minute: The number to use as a minute value.
  • second: The number to use as a second value.

Notes

  • In a valid date, serial number integer represents the date and the decimal part represents time.
  • 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.

Example

To master the TIME function we need to try it out in an example and below is one which you can try out:

In the below example, we have used different arguments:

  • Time returns by this function are in 12-hour format.
  • If you use zero for the hour value it will give you time from the starting hour of a day.
  • When you specify a negative number it will deduct that value from the previous hour, minute or second.
  • The time function returns a decimal number which represents a particular time in Excel.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.