Countdown Timer Template
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDFGHIJKLMNOPQRSTUVWXYZAA
1
YOU DON'T NEED TO REQUEST ACCESS TO THIS DOCUMENT
2
3
1
Check out the explanation here - https://www.michaelkwan.me/make-countdown-timer-google-sheets-gsheets/
4
2
Go to File-> Make a copy to add it to your GDrive (no extra permissions needed), then go have fun with it
5
6
Current time5:41:40 AM
7
8
Instructions:1. Insert duration**2. Copy current time (cell C1), paste below as value (ctrl+shift+V)3. See here for results.4. This sheet refreshes every minute or when updated. To manually refresh, simply type something anywhere in the sheet
9
10
No.NameDurationStartCountdown
11
1Sample description1:00:0012:59:46 PMCOMPLETE
12
25:00:00COMPLETE
13
34:00:00COMPLETE
14
40:01:00COMPLETE
15
50:00:00COMPLETE
16
60:00:00COMPLETE
17
70:00:00COMPLETE
18
80:00:00COMPLETE
19
90:00:00COMPLETE
20
100:00:00COMPLETE
21
22
**You can also insert total minutes and GSheet will convert it for you. E.g. 00:120:00, hit Enter, and GSheet will automatically turn it into 02:00:00
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...