https://community.jmp.com/t5/Discussions/How-to-add-and-subtract-time-quickly-in-the-form-of-text-minutes/m-p/845097#M101972 <P>How to get the new text format value after the variable is in text format content, is the value of the minute and second, and how to make it +5 seconds<BR />Is there an exi</P><P>&nbsp;</P><P>Thanks!</P><PRE><CODE class=" language-jsl">ti="00:59:59"; ti=ti+5; //ti="01:00:04";</CODE></PRE> Sat, 01 Mar 2025 06:23:12 GMT lala 2025-03-01T06:23:12Z https://community.jmp.com/t5/Discussions/How-to-add-and-subtract-time-quickly-in-the-form-of-text-minutes/m-p/845097#M101972 <P>How to get the new text format value after the variable is in text format content, is the value of the minute and second, and how to make it +5 seconds<BR />Is there an exi</P><P>&nbsp;</P><P>Thanks!</P><PRE><CODE class=" language-jsl">ti="00:59:59"; ti=ti+5; //ti="01:00:04";</CODE></PRE> Sat, 01 Mar 2025 06:23:12 GMT https://community.jmp.com/t5/Discussions/How-to-add-and-subtract-time-quickly-in-the-form-of-text-minutes/m-p/845097#M101972 lala 2025-03-01T06:23:12Z https://community.jmp.com/t5/Discussions/How-to-add-and-subtract-time-quickly-in-the-form-of-text-minutes/m-p/845107#M101973 <P>Format + Informat</P> <PRE><CODE class=" language-jsl">Right("00" || Format(In Format(ti, "hr:m:s") + 5, "hr:m:s"), 8) </CODE></PRE> Sat, 01 Mar 2025 06:28:55 GMT https://community.jmp.com/t5/Discussions/How-to-add-and-subtract-time-quickly-in-the-form-of-text-minutes/m-p/845107#M101973 jthi 2025-03-01T06:28:55Z