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:

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 »
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 »
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 »
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 »