Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

TIME

Return date by combining Hour, Minute and Seconds in Excel
Returns the serial number of a particular time

Rational

Return time by combining Hour, Minute and Seconds.

Description

The Excel TIME function returns the time value by merging the three components: the hour, minute, and second. Example to add all three part of a time, use =TIME(9,15,35), that may returns “09:15:35”.
The formula is used where the application generates one or more of these components and return value must have proper time out of them.

Syntax

=TIME (hour, minute, second)

Parameters

hour – An Integer between 0 and 23
minute – An Integer between 0 and 59
second – An Integer between 0 and 59

Return Value

The return value is a decimal number or time depending upon the cell format.

Key Notes

  • TIME function returns a serial number based on the supplied argument of all three components. You can use DATE function to get a date by entering the year, month, and day.
  • An invalid argument is also accepted, and the return value is adjusted accordingly. For example, in an hour there are 60 minutes, but if a user enters 80 minutes, Excel considers it 1 Hour 20 minutes and alters the result accordingly, similarly with hours and seconds.
  • The TIME() function doesn’t enable a user to add or subtract a time component from result directly.
  • Change Number formatting to date and/or time.
  • Excel store date and time in serial number format, a number from 0 (12:00:00 AM) to 0.999988426 (11.59:59 PM). The serial number can easily get convert by changing cell format to date.

Keep Reading Similar Functions:

Find hour component from a time value in Excel

HOUR

The Excel HOUR function returns the hour component of a timestamp between 0 (12:00 A.M.) and 23 (11:59 P.M.), use =HOUR(0.3) that returns ‘7’ (0.3*24).

Read More »
Returns the seconds component from a time value in Excel

SECOND

The SECOND function returns the second component (a number from 0 to 59). Example, 6:48:15 PM, the SECOND function will return ‘15’.

Read More »
Find minute component from a timevalue in Excel

MINUTE

The MINUTE function returns the minute component of a time value. For example, with a time of 6:48 PM or text, =MINUTE(time) will return ’48’.

Read More »
Returns current date and time in Excel.

NOW

The NOW function returns the serial number of the current date and time. Example; to show the current date and time, use NOW(), empty parenthesis.

Read More »
Get a date by entering the year, month, and day in Excel

DATE

The DATE function returns a date value using year, month and date, sequentially. I.e.; to merge all 3 date component, =DATE(2012,12,4) returns “04-12-2012”.

Read More »