How to set stopwatch start and stop time: duration

I see there is a place to put the start and end times. How would I write that? For example, I want a 5min stop watch. In the start time cell I am thinking it should be current time and ending time 5 min afterward, but not sure how to write those two times in the cells they are linked to in the sheet.

They are not really start and end times. It’s more of a placeholder column that works best with user specific columns. When you click on the Play button, the current time is stored in the Start Time column and Glide does some math behind the scenes to she the elapsed time from that saved time. When you click on Pause, the calculated duration is stored in the duration column. When you click on play, the new current time is stored in the Start Time column, and the calculated duration is added to the elapsed time. Clicking on Stop clears out both columns so it’s ready for the next time you click on Play. Technically you can manipulate the columns in other ways, but a countdown timer like you want wouldn’t work great. From what I’ve seen, countdown doesn’t look very good.

image

3 Likes

I am not sure if this would help but the glide team made an app to showcase how it works.

You can find it here and see if it would help you figure it out.

2 Likes

Ok, thanks for the intel. Yea, I have scenarios where the students need stopwatches to keep track of how long their gaming powers have left until they expire…but this is a good start.

Sweet, thanks Santiago. I will check it out…

1 Like

Ahh that was awesome- I saw where they added free run tacker, that will work perfectly for the spaceship. Now the crew can time their flight times between destinations to calculate distance or speed.

1 Like

If you don’t need “to the second” tracking of time like the stopwatch does, you can always obtain a future date time and do the duration math in a math column, then show it however you want. You can show the calculated duration on the screen, but it will most likely update every 5 or 10 seconds instead of “to the second”, like the stopwatch.

1 Like

Good to know, thank you, Jeff. I can tinker around with that approach.

1 Like