Related Topics: | ||
Description: Returns the serial number for a specified time, where the HOUR, MINUTES and SECONDS are separated by commas. For example, =TIME(16,48,10) returns 0.700115741, which is the serial number that is equivalent to 4:48:10 PM.
The decimal number returned by TIME is a value ranging from 0 (zero) to 0.99999999, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 PM.).
Syntax: TIME(Hour, Minute, Second)
Hour is a number from 0 (zero) to 32767 representing the hour. Any value greater than 23 will be divided by 24 and the remainder will be treated as the Hour value. For example, TIME(27, 0, 0) = TIME(3, 0, 0) = .125 or 3:00 AM.
Minute is a number from 0 to 32767 representing the minute. Any value greater than 59 will be converted to hours and minutes. For example, TIME(0, 750, 0) = TIME(12, 30, 0) = .520833 or 12:30 PM.
Second is a number from 0 to 32767 representing the second. Any value greater than 59 will be converted to hours, minutes, and seconds. For example, TIME(0, 0, 2000) = TIME(0, 33, 22) = .023148 or 12:33:20 AM.
Remarks:
Time values are a portion of a date value and represented by a decimal number (for example, 12:00 PM is represented as 0.5 because it is half of a day).
Example:
TIME(12, 0, 0) = 0.5 [this is the serial number that is equivalent to 12:00:00 PM.]
TIME(16, 48,10) = 0.700115741 [this is the serial number that is equivalent to 4:48:10 PM.]
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.