TIME
Formula Explanation
Returns a decimal number representing a specific time.
The decimal number returned by TIME represents a value between 0 (zero) and 0.99988426, which corresponds to the time range from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 PM).
Formula Syntax
Enter in the result column: TIME(hour, minute, second)
The TIME function syntax has the following arguments:
Hour (required): A number between 0 and 32767 representing hours. Any value greater than 23 will be divided by 24, and the remainder will be used as the hour value. For example, TIME(27,0,0) = TIME(3,0,0) = .125 or 3:00 AM.
Minute (required): A number between 0 and 32767 representing minutes. Any value greater than 59 will be converted into hours and minutes. For example, TIME(0,750,0) = TIME(12,30,0) = .520833 or 12:30 PM.
Second (required): A number between 0 and 32767 representing seconds. Any value greater than 59 will be converted into hours, minutes, and seconds. For example, TIME(0,0,2000) = TIME(0,33,22) = .023148 or 12:33:20 AM.
Usage Example
Calculate the decimal number corresponding to the time in column ER2.
TIME("09", "25", "40")