How to add and subtract time quickly in the form of text minutes and seconds?

Question

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
Is there an exi

Thanks!

ti="00:59:59";
ti=ti+5;
//ti="01:00:04";

jthi · Accepted Answer

Format + Informat

Right("00" || Format(In Format(ti, "hr:m:s") + 5, "hr:m:s"), 8)