Hello! Does anyone have any thoughts on this, I need a formula for example for a progress bar, or more precisely for two progress bars. Where the first one moves forward in an even minute using seconds (1-60), and the second one moves back (60-1). And so that the first one is visible in even minutes, the second one in odd minutes. So, I need 2 formulas…
Well, or at least make progress bars work, one for even numbers, the second for odd (the formula is most likely for transparency). The first question for my idea, I can try to solve with color.
Do you want the Arcs to progress 360 degrees or 180 . You may want rectangular progress bars . Peter Posted a Test Earlier on another topic with a similar request . That was for odd and even seconds . It will be very easy to convert that to Minutes . If you want the Colour to change , yes you will have to use Two Progress. We have no way of making a colour change with a Tag .
.
Now I only need a formula so that one progress bar works on even numbers, the second on odd numbers and that’s it.
The idea is that an image divided into seconds and visible with the help of a progress bar, shows the time of seconds clockwise incrementally, and then with the help of a second such image and a second progress bar shows the reverse order, the same clockwise forward. I solved it with the help of “counterclockwise” and a countdown formula.
All that’s left is for one progress bar to work on even minutes, the second on odd minutes.
So You Got the Moves You Just Need to Switch them on and Off with Opacity I would say . Try ((([MIN]%2)==1)?100:0)
For your Opacity Value . Remembering to Zero the static Value . For the alternate one use ==0 instead of ==1 .
Thank you! It worked ))) Although I don’t fully understand how the formula with % works, the logic. I roughly understand what happens, but how it works is a bit difficult to understand.
