TIME

Description

This function returns the decimal number for a particular time. The total time for the day is considered as equal to 1 and the time that is calculated from the function represents what fraction of 1 is covered until then.

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 which is 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 seconds. 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

All the arguments are compulsory.
Time values are a portion of a date value (SERIAL NUMBER) 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 (21, 45, 06)	-The parameters for Hour, Minutes and Seconds, are converted to the time returned by this function which is a number converted into decimal value. (The time returned for this function is " 0.91")
=TIME ("range")	-The parameters for Hour, Minutes and Seconds can be specified from a given range instead of being fed into the formula directly and the TIME can be calculated based on the values thus passed to the formula.