Subtract Seconds

This function subtracts a value in seconds from a specific time. For instance, assume you subtract 25 seconds from the 2:10:42 time by using the SUBSECONDS() function. When the SUBSECONDS() function is executed, it will return 2:10:17 as the value of time after it subtracts 25 seconds from the 2 hours, 10 minutes, and 42 seconds.

You can use the SUBSECONDS() function as follows:

To use the SUBSECONDS function:

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

2. In the Search box, enter subseconds to display the SUBSECONDS function.

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

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

6. In the list, select the Static function to display it with the value and String parameters.
7. In the Static function, click the value parameter and then enter a time (for example, 2:10:42) in hh:mm:ss format.

Note:- The 2:10:42 value specifies the time with 2 hours, 10 minutes, and 42 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 SUBSECONDS function, click the format parameter and then enter hh:mm:ss in the place of the format parameter.

9. In the SUBSECONDS function, click the seconds 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, 25) that you want to subtract from the earlier defined value of time (for example, 2:10:42) in the first parameter.