How can I convert the stopwatch into timer


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.

1 Like

Yes, it sounds good enough for me. Can you please tell me the process?

Here you go:

To get that, I used 6 columns:

  1. A math column to get the current time

  2. A math column to determine the number of whole minutes remaining

  3. 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
Screen Shot 2021-09-30 at 4.46.17 PM

Screen Shot 2021-09-30 at 4.46.29 PM

  1. 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.

1 Like

okay thank you very much

I am getting this kind of row id

1 Like

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