I did this in my google sheet But I don’t know how can I make a timer in glide
You can’t “convert” the stop watch into a timer. Because, well… it’s a stopwatch, and a stopwatch is not a timer.
Can you describe your use case?
There might be an approach that can be suggested if it’s understood what you want to achieve.
I want to make a countdown timer that will play for 25 min. and the count will have to show. I meant It will behave like a timer
This can be done with a couple of math columns, but it will only update approximately once every 10 seconds. Is that good enough for your purpose?
If you need to see the seconds counting down second by second, then it probably needs an experimental code solution.
Yes, it sounds good enough for me. Can you please tell me the process?
Here you go:
To get that, I used 6 columns:
-
A math column to get the current time
-
A math column to determine the number of whole minutes remaining
-
A math column to determine the number of seconds remaining (after subtracting the number of whole minutes)
4 & 5.Two if-then-else columns, to determine if zero padding is required for display
- A template column to use to display the time remaining
Thank you very much for your support
Those two columns are optional, they are just used to provide zero padding if the number of minutes or seconds remaining is less than 10.
So instead of 9:7
, you get 09:07
Thank you very much
Can you please say how you get now.
okay thank you very much
I don’t have any Now column and I don’t understand how can I get Now.
You don’t need a column called Now.
Now is a special value that can be used as a replacement in a math column.
Did you watch the short video that I posted above?
Yes I found thank you very much