Excel TIME Function

This post will guide you how to use Excel TIME function with syntax and examples in Microsoft excel.

Description

The Excel TIME function returns a date in serial number format for a particular time (the hour, minute and second).

The serial number returned by TIME function is a value between 0 and 0.99988426. And the result of 0 represents 12:00:00 AM and the result of 0.99988426 represents 11:59:59 PM.

So this function can be used to create a time with hours, minutes, and seconds. And it also will return a decimal number representing a particular time in excel.

The TIME function is a build-in function in Microsoft Excel and it is categorized as a DATE and TIME Function.
The TIME function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

Syntax

The syntax of the TIME function is as below:

= TIME(hour, minute, second)

Where the TIME function arguments are:

  • Hour -This is a required argument. A number from 0 (zero) to 32767 representing the hour. If the value is greater than 23 and then it will be divided by 24 and the remainder will be treated as the hour value. For example, the TIME(28,0,0) is equal to TIME(4,0,0).
  • Minute – This is a required argument. A number from 0 to 32767 representing the minute. If the minute value is greater than 59 and it will be converted to hours and minutes (it means that every 60 minutes will add one hour to hour value). For example, TIME(1,75,0) = TIME(2,15,0).
  • Second – This is a required argument. A number from 0 to 32767 representing the second. If the second value is greater than 59 and it will be converted to hours, minutes, and seconds (it means that every 60 seconds will add 1 minute to minute value). For example, TIME(1,20,75) = TIME(1,21,15) .

Excel TIME Function Examples
The below examples will show you how to use Excel TIME function to create a decimal number representing a particular time.

#1 =TIME(A2,B2,C2)

excel time function example1

Related Posts

How to Compare Time Difference with Certain Time in Excel
Compare Time Difference with Certain Time 3

Sometimes we need to count time difference when participating a contest or an exam, and if the time difference (between start time and end time) is greater than certain time, participants are failed in the contest. So, in this situation ...

How to Convert Text to Time in Excel
convert text to time7

This post will guide you how to convert time string to time in Excel. Assuming that you have a list of text string in your worksheet, and you wish to convert these time string to standard time format, how to ...

How to Extract Time From A Date And Time in Excel
extract time from date and time11

This post will guide you how to extract time portion from a date and time in Excel. How do I remove date on Date/Time Stamp with a formula in Excel. How to remove date from a date and time value ...

Extract Time or Hour Only from a Date and Time in Excel
extract time and hour7

This post will guide you how to extract time from a data and time value with a formula in Excel. How do I extract time from a date-time number in Excel 2013/2016. How to extract hour only from the date ...

Adding Hours, Minutes, or Seconds to a Date and Time in Excel
adding dates4

This post will guide you how to add hours, minutes, or seconds to a given date and time in a cell in Excel. How do I add hours, minutes or seconds to a time with a formula in Excel. How ...

Excel XIRR Function
excel xirr examples1

This post will guide you how to use Excel XIRR function with syntax and examples in Microsoft excel. Description The Excel XIRR function returns the internal rate of return for a series of cash flows that is not necessarily periodic. ...

Excel VDB Function
excel vdb examples1

This post will guide you how to use Excel VDB function with syntax and examples in Microsoft excel. Description The Excel VDB function calculates the depreciation of an asset for a specified period based on the double declining balance method. ...

Excel SYD Function
excel syd examples1

This post will guide you how to use Excel SYD function with syntax and examples in Microsoft excel. Description The Excel SYD function calculates the sum-of-years’digits depreciation of an asset for a specified period. And it will return a numeric ...

Excel SLN Function
excel sln examples1

This post will guide you how to use Excel SLN function with syntax and examples in Microsoft excel. Description The Excel SLN function calculates the depreciation of an asset for one period based on the straight line depreciation. And it ...

Excel PV Function
excel pv examples1

This post will guide you how to use Excel PV function with syntax and examples in Microsoft excel. Description The Excel PV function returns the present value of a loan or investment based on constant payments and a constant interest ...

Sidebar