cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

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

lala
Level VIII

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";
1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

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

Format + Informat

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

View solution in original post

1 REPLY 1
jthi
Super User

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

Format + Informat

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