The TIME function calculates the time code from a supplied hour, minute and second. This enables you to display the time in a format of your choice. The arguments for TIME are entered according to the 24-hour clock.
For example, the formula
TIME(22,20,40)
returns a time code of 0.93101852 and is equivalent 10:20:40 PM, which is the displayed default format.
Note that the formulas TIME(0, 0, 0) and TIME(24, 0, 0) return time codes of 0 and 1 respectively.
See also: