Add Minutes

This function adds a value in minutes to a specific time. For instance, assume you add 30 minutes to the 2:10:34 time by using the ADDMINUTES() function. When the ADDMINUTES() function is executed, it will return 2:40:34 as the value of time after it adds 30 minutes to the 2 hours, 10 minutes, and 34 seconds.

You can use the ADDMINUTES() function as follows:

To use the ADDMINUTES function:

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

2. In the Search box, enter addminutes to display the ADDMINUTES function.

3. In the list, select the ADDMINUTES function to display it with the time, format, and minutes parameters.

4. In the ADDMINUTES 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:10:34) in hh:mm:ss format.

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

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

9. In the ADDMINUTES function, click the minutes 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, 30) that you want to add to the earlier defined value of time (for example, 2:10:34) in the first parameter.