Skip to content
Copy of Playground Doc - [SHARED]
About
Table Sort Control
One Click Timer
Time in 1/100 second
Button to log time
Click Thru Button
Working Days Remaining
Working Hours
Delete Empty Rows
Multiple Ranked Lists
Three Most Recent Rows
Search with Regex
Search with Clear Search Button
Search with Accuracy Meter
Find Tags in a Post
Language Translations
Split First and Last Names
Mark Row as Opened
Project Tasks for CAD
Random Numbers
In List 1 not in List 2
Custom Units
Reverse a String or Number
Barcodes / Check Digits
Luhn Algorithm
vCard QR Code
Scientific Notation Display
Lookup Column Schema
Price by Date
Time Zones
Pixel Image
More
Share
Explore

One Click Timer

If you click "Start" on a different task while one task is still running, this will stop the first and start the next with one click.
Timer Tasks
0
Task
Time Spent
Start/Stop
Clock ins
Clock outs
*
Track
1
Task 1
36 secs
⁠
⁠
Start
1/4/2020 8:10:20 PM1/4/2020 8:10:47 PM2/4/2020 12:31:58 PM
1/4/2020 8:10:34 PM1/4/2020 8:11:06 PM2/4/2020 12:32:01 PM
Track
2
Task 2
12 secs
⁠
⁠
Start
1/4/2020 8:10:35 PM
1/4/2020 8:10:47 PM
Track
3
Task 3
-
⁠
⁠
Start
​
​
Track
There are no rows in this table
⁠
This is based on the "Timer with pause" posted by Paul_Danyliuk:
⁠
Simple timer with pause/continue capability (single table design)
⁠
⁠

One Click Timer - More robust formula schema


This is a more robust formula that will enforce values to be read in as Date/Time values and will also ensure duration calculations. If you're editing by hand, this will deal with any issues of values being converted to text.
Timer Tasks 2
0
Task
Time Spent
Start/Stop
Clock ins
Clock ins Converted
Clock outs
Clock outs Converted
*
Track
1
Task 1
36 secs
⁠
⁠
Start
1/4/2020 8:10:20 PM1/4/2020 8:10:47 PM1/10/2020 2:27:58 PM
1/4/2020 8:10:20 PM1/4/2020 8:10:47 PM1/10/2020 2:27:58 PM
1/4/2020 8:10:34 PM1/4/2020 8:11:06 PM1/10/2020 2:28:01 PM
1/4/2020 8:10:34 PM1/4/2020 8:11:06 PM1/10/2020 2:28:01 PM
Track
2
Task 2
12 secs
⁠
⁠
Start
1/4/2020 8:10:35 PM
1/4/2020 8:10:35 PM
1/4/2020 8:10:47 PM
1/4/2020 8:10:47 PM
Track
3
Task 3
-
⁠
⁠
Start
​
​
Track
There are no rows in this table
⁠

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.