Excel 2000 in a Nutshell

Name

TIME

Synopsis

Use this function to create a time by combining values that indicate the hour, minutes, and seconds. You must specify all three values for this function. If you don’t want any seconds, for example, you still need to pass a value of 0 to the function. When you use this function you can either reference other cells that contain the values, such as TIME(A1, A2, A3), where cell A1 contains the Hour value, cell A2 contains the Minute value, and cell A3 contains the Second value, or you can type in specific values for the hour, minutes, and seconds.

The value returned by TIME is actually a decimal value that represents the time. For example, Excel stores 6:00 PM as 0.75. Excel automatically formats the cell with the default time format, but you can see the actual numeric value by changing the cell formatting back to General. For more information about how Excel stores time values refer to Section 13.1 earlier in this chapter.

To Calculate

=TIME(Hour, Minute, Second)

Hour

Excel accepts an hour value of one or two digits (between 0 and 23).

Minute

The value of the Minute argument must be an integer representing the minute portion of the time. If the value specified is greater than 59, one hour is added to the Hour argument for each value of 60 that can be subtracted from the Minute argument. For example, if the value of the Minute argument is 64, a value of 1 is added to the hour and the minute value is 4.

Second

The value of the Second argument must be an integer representing ...