How to use the Excel TIME function

The following article we share with you the TIME function in Excel – This is one of the functions in the group of date and time functions that are commonly used in Excel.

Syntax: =TIME( hour, minute, second )

The TIME function syntax has the following arguments:

  • hour:  A number from 0 to 32767, representing the hour. If the hour value is greater than 23, it will be divided by 24 and the remainder will be used as the hour value. This means that TIME(24,0,0) is equal to TIME(0,0,0) and TIME(25,0,0) is equal to TIME(1,0,0) … and so on.
  • minute: A number from 0 to 32767, representing the minute. If the minute value is greater than 59, then every 60 minutes will add 1 hour to the hour value. This means that TIME(0,60,0) is equal to TIME(1,0,0) and TIME(0,120,0) is equal to TIME(2,0,0) … and so on.
  • second: A number from 0 to 32767, representing the second. If the second value is greater than 59, then every 60 seconds will add 1 minute to the minute value. This means that TIME(0,0,60) is equal to TIME(0,1,0) and TIME(0,0,120) is equal to TIME(0,2,0) … and so on.

Example: Let’s look at some Excel TIME function examples and explore how to use the TIME function as a worksheet function in Microsoft Excel:

excel time - How to use the Excel TIME function

Syntax: =TIME(A2,B2,C2) 

Result:

excel time 1 - How to use the Excel TIME function

=TIME(A3,B3,C3)
Result: 4:45:30 PM

=TIME(A4,B4,C4)
Result: 10:30:00 PM

=TIME(A5,B5,C5)
Result: 7:00:30 PM

=TIME(A6,B6,C6)
Result: 1:30:30 AM

READ:  How to use the Excel NETWORKDAYS function

Add a Comment

Your email address will not be published. Required fields are marked *