Subtract Minutes

This function subtracts a value in minutes from a specific time. For instance, assume you subtract 14 minutes from the 2:30:34 time by using the SUBMINUTES() function. When the SUBMINUTES() function is executed, it will return 2:16:34 as the value of time after it subtracts 14 minutes from the 2 hours, 30 minutes, and 34 seconds.

You can use the SUBMINUTES() function as follows:

To use the SUBMINUTES function:

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

2. In the Search box, enter subminutes to display the SUBMINUTES function.

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

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

Note:- The 2:30:34 value specifies the time with 2 hours, 30 minutes, and 34 seconds. If you do not want to enter the time manually by using the Static function, you can fetch the value of the time from an element or entity. To know more about defining the value in the entity, visit the post, Using Entity with Date and Time Functions.

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

9. In the SUBMINUTES 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, 14) that you want to subtract from the earlier defined value of time (for example, 2:30:34) in the first parameter.