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

[#1]

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";

[#2 · Accepted solution]

Format + Informat

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