Add Hours

This function adds a specific value of hour unit to a specific time. For instance, assume you add 10 hours to a time, 2:10:34. When the ADDHOURS() function is executed, it will return 12:10:34 as the value of time after it adds 10 hours to the 2 hours:10 minutes:34 seconds value of the time.

You can use the ADDHOURS() function as follows:

To use the ADDHOURS() function:

1. Click in the smart selector to display the Search box.

2. In the Search box, enter addhours to display the ADDHOURS function.

3. In the list, select ADDHOURS to display the ADDHOURS(time, format, hours) function.

4. In the ADDHOURS function, click the time parameter to display the Search box.
5. In the Search box, enter static to display the Static function.

6. Select the Static function.
7. In the Static function, click the value parameter, and then enter a time (for example, 2:34:33) in hh:mm:ss format.

Note:- The 2:34:33 value specifies the time with 2 hours, 34 minutes, and 33 seconds.

8. In the ADDHOURS function, click format, and then enter hh:mm:ss in the place of the format parameter.

9. In the ADDHOURS function, click the hours parameter to display the Search box.
10. In the Search box, enter static to display the Static function.

11. In the list, select the Static function.

12. In the Static function, click the value parameter, and then enter a numeric value (for example, 8) that you want to add to the earlier defined value of time (for example, 2:34:33) in the first parameter.