# How can I convert the stopwatch into timer **URL:** \ **Category:** Ask for Help\ **Created:** [September 30, 2021, 5:13am UTC](https://community.glideapps.com/t/how-can-i-convert-the-stopwatch-into-timer/32496 "2021-09-30T05:13:20Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![Moumita\_Baral](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moumita_baral/32/32412_2.png) [@Moumita\_Baral](https://community.glideapps.com/u/Moumita_Baral)\ **Post date:** [September 30, 2021, 5:13am UTC](https://community.glideapps.com/t/how-can-i-convert-the-stopwatch-into-timer/32496/1 "2021-09-30T05:13:20Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/8/681b4afddd9a3be085d62c0f86e47bc77ad6151b.png) I did this in my google sheet But I don’t know how can I make a timer in glide ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 30, 2021, 6:17am UTC](https://community.glideapps.com/t/how-can-i-convert-the-stopwatch-into-timer/32496/2 "2021-09-30T06:17:15Z")
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. ---
**Author:** ![Moumita\_Baral](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moumita_baral/32/32412_2.png) [@Moumita\_Baral](https://community.glideapps.com/u/Moumita_Baral)\ **Post date:** [September 30, 2021, 6:41am UTC](https://community.glideapps.com/t/how-can-i-convert-the-stopwatch-into-timer/32496/3 "2021-09-30T06:41:08Z")
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 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 30, 2021, 6:54am UTC](https://community.glideapps.com/t/how-can-i-convert-the-stopwatch-into-timer/32496/4 "2021-09-30T06:54:06Z")
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. ---
**Author:** ![Moumita\_Baral](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moumita_baral/32/32412_2.png) [@Moumita\_Baral](https://community.glideapps.com/u/Moumita_Baral)\ **Post date:** [September 30, 2021, 8:29am UTC](https://community.glideapps.com/t/how-can-i-convert-the-stopwatch-into-timer/32496/5 "2021-09-30T08:29:34Z")
> [@Darren\_Murphy](#): > > 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? Yes, it sounds good enough for me. Can you please tell me the process? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 30, 2021, 8:53am UTC](https://community.glideapps.com/t/how-can-i-convert-the-stopwatch-into-timer/32496/6 "2021-09-30T08:53:19Z")
Here you go: ![Screen Shot 2021-09-30 at 4.45.02 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/3/73b2713bb04ab7bce43e56dc8908dac3912adce2.png) To get that, I used 6 columns: ![Screen Shot 2021-09-30 at 4.45.19 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/4/444032bf5ac3c6fc28e3a6782ca3577e45872886.png) 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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/a/5ac24e365f9a4e5a1b8f9fb38117ddb0c612be61.png) ![Screen Shot 2021-09-30 at 4.46.29 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/a/da25a5882ba4d7d2cfd83c54275a482d91a71b20.png) 1. A template column to use to display the time remaining ![Screen Shot 2021-09-30 at 4.46.45 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/d/0d3ad93e76763eb6b48bff056ec52c1de0206367.png) ---
**Author:** ![Moumita\_Baral](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moumita_baral/32/32412_2.png) [@Moumita\_Baral](https://community.glideapps.com/u/Moumita_Baral)\ **Post date:** [September 30, 2021, 9:20am UTC](https://community.glideapps.com/t/how-can-i-convert-the-stopwatch-into-timer/32496/8 "2021-09-30T09:20:28Z")
Thank you very much for your support ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 30, 2021, 9:20am UTC](https://community.glideapps.com/t/how-can-i-convert-the-stopwatch-into-timer/32496/9 "2021-09-30T09:20:51Z")
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` ---
**Author:** ![Moumita\_Baral](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moumita_baral/32/32412_2.png) [@Moumita\_Baral](https://community.glideapps.com/u/Moumita_Baral)\ **Post date:** [September 30, 2021, 9:27am UTC](https://community.glideapps.com/t/how-can-i-convert-the-stopwatch-into-timer/32496/10 "2021-09-30T09:27:44Z")
Thank you very much ---
**Author:** ![Moumita\_Baral](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moumita_baral/32/32412_2.png) [@Moumita\_Baral](https://community.glideapps.com/u/Moumita_Baral)\ **Post date:** [October 1, 2021, 3:31pm UTC](https://community.glideapps.com/t/how-can-i-convert-the-stopwatch-into-timer/32496/11 "2021-10-01T15:31:26Z")
Can you please say how you get now. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 1, 2021, 3:34pm UTC](https://community.glideapps.com/t/how-can-i-convert-the-stopwatch-into-timer/32496/12 "2021-10-01T15:34:13Z")
![Screen Shot 2021-10-01 at 11.33.31 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/b/8bb6e3e8b27b7250058525c9239d560c8e04c301.png) ---
**Author:** ![Moumita\_Baral](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moumita_baral/32/32412_2.png) [@Moumita\_Baral](https://community.glideapps.com/u/Moumita_Baral)\ **Post date:** [October 1, 2021, 3:36pm UTC](https://community.glideapps.com/t/how-can-i-convert-the-stopwatch-into-timer/32496/13 "2021-10-01T15:36:42Z")
okay thank you very much ---
**Author:** ![Moumita\_Baral](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moumita_baral/32/32412_2.png) [@Moumita\_Baral](https://community.glideapps.com/u/Moumita_Baral)\ **Post date:** [October 1, 2021, 3:56pm UTC](https://community.glideapps.com/t/how-can-i-convert-the-stopwatch-into-timer/32496/14 "2021-10-01T15:56:08Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/b/db14a307cb6a793b75cdb22f7c4857391ef39b1a.png) I am getting this kind of row id ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 1, 2021, 4:00pm UTC](https://community.glideapps.com/t/how-can-i-convert-the-stopwatch-into-timer/32496/15 "2021-10-01T16:00:40Z")
---
**Author:** ![Moumita\_Baral](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moumita_baral/32/32412_2.png) [@Moumita\_Baral](https://community.glideapps.com/u/Moumita_Baral)\ **Post date:** [October 1, 2021, 4:03pm UTC](https://community.glideapps.com/t/how-can-i-convert-the-stopwatch-into-timer/32496/16 "2021-10-01T16:03:03Z")
I don’t have any Now column and I don’t understand how can I get Now. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 1, 2021, 4:15pm UTC](https://community.glideapps.com/t/how-can-i-convert-the-stopwatch-into-timer/32496/17 "2021-10-01T16:15:29Z")
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? ---
**Author:** ![Moumita\_Baral](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moumita_baral/32/32412_2.png) [@Moumita\_Baral](https://community.glideapps.com/u/Moumita_Baral)\ **Post date:** [October 1, 2021, 4:30pm UTC](https://community.glideapps.com/t/how-can-i-convert-the-stopwatch-into-timer/32496/18 "2021-10-01T16:30:42Z")
Yes I found thank you very much ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:50pm UTC](https://community.glideapps.com/t/how-can-i-convert-the-stopwatch-into-timer/32496/19 "2024-01-17T16:50:26Z")