Use the TIME function to combine single time parts - Date and Time Functions - Microsoft Excel Tutorials

Use the TIME function to combine single time parts using Microsoft Excel

The worksheet in Figure 4-29 shows single time parts in each column. 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 function. 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 be converted to hours and minutes.
second: A number from 0 to 59 that represents seconds. Any value greater than 59 will be converted to hours, minutes, and seconds.

To combine single time parts into a valid time:

1. Select cells E2:E10 and type the formula =TIME(B2,C2,D2).
2. Press <-Ctrl+Enter->.
3. From the Format menu, select Cells.
4. Select the Number tab and click Custom under Category.
5. Enter hh:mm:ss as the custom format.
6. Click OK.

Use the TIME function to combine single time parts