Microsoft Excel Functions & Formulas

Use the TIME function to combine single

time parts

The worksheet in Figure 4-29 shows single time parts in each col-

umn. Column B contains hours, column C contains minutes, and

column D contains seconds. All three columns have to be combined

into one time as shown in column E. To do this, use the TIME func-

tion. This function returns the decimal number for a particular

time. The syntax is:

TIME(hour, minute, second)

hour: A number from 0 to 23 that represents the hour. Any

value greater than 23 will be divided by 24 and the remainder

will be treated as the hour value.

minute: A number from 0 to 59 that represents minutes. Any

value greater than 59 will ...