Spreadsheet: 840349d1692673261-data-validation-drop-list-not-highlighting-previously-entered-time-value-dhodgman-dropdown-sample
Sheet: Settings

Time Intervals |  |  | String values
00:00:00 |  |  | a
00:06:00.029000 |  |  | b
00:11:59.971000 |  |  | c
00:15:00.029000 |  |  | d
00:18:00 |  |  | e
00:24:00.029000 |  |  | f
00:29:59.971000 |  |  | g
00:36:00
00:42:00.029000
00:45:00 |  | String value | a | When dropdown list is opened, the previously entered value is selected
00:47:59.971000
00:54:00
01:00:00.029000
01:05:59.971000 |  | Time value | 14:42:00 | When dropdown list is opened, the first option is selected
01:12:00
01:14:59.971000 |  | Time Value | 177 | Selected value is stored in D17
01:18:00.029000
01:23:59.971000
01:30:00
01:36:00.029000
01:41:59.971000
01:45:00.029000
01:48:00
01:54:00.029000
01:59:59.971000
02:06:00
02:12:00.029000
02:15:00
02:17:59.971000
02:24:00
02:30:00.029000
02:35:59.971000
02:42:00
02:44:59.971000
02:48:00.029000
02:53:59.971000
03:00:00
03:06:00.029000
03:11:59.971000
03:15:00.029000
03:18:00
03:24:00.029000
03:29:59.971000
03:36:00
03:42:00.029000
03:45:00
03:47:59.971000
03:54:00
04:00:00.029000
04:05:59.971000
04:12:00
04:14:59.971000
04:18:00.029000
04:23:59.971000
04:30:00
04:36:00.029000
04:41:59.971000
04:45:00.029000
04:48:00
04:54:00.029000
04:59:59.971000
05:06:00
05:12:00.029000
05:15:00
05:17:59.971000
05:24:00
05:30:00.029000
05:35:59.971000
05:42:00
05:44:59.971000
05:48:00.029000
05:53:59.971000
06:00:00
06:06:00.029000
06:11:59.971000
06:15:00.029000
06:18:00
06:24:00.029000
06:29:59.971000
06:36:00
06:42:00.029000
06:45:00
06:47:59.971000
06:54:00
07:00:00.029000
07:05:59.971000
07:12:00
07:14:59.971000
07:18:00.029000
07:23:59.971000
07:30:00
07:36:00.029000
07:41:59.971000
07:45:00.029000
07:48:00
07:54:00.029000
07:59:59.971000
08:06:00
08:12:00.029000
08:15:00
08:17:59.971000
08:24:00
08:30:00.029000
08:35:59.971000
08:42:00
08:44:59.971000
08:48:00.029000
08:53:59.971000
09:00:00
09:06:00.029000
09:11:59.971000
09:15:00.029000
09:18:00
09:24:00.029000
09:29:59.971000
09:36:00
09:42:00.029000
09:45:00
09:47:59.971000
09:54:00
10:00:00.029000
10:05:59.971000
10:12:00
10:14:59.971000
10:18:00.029000
10:23:59.971000
10:30:00
10:36:00.029000
10:41:59.971000
10:45:00.029000
10:48:00
10:54:00.029000
10:59:59.971000
11:06:00
11:12:00.029000
11:15:00
11:17:59.971000
11:24:00
11:30:00.029000
11:35:59.971000
11:42:00
11:44:59.971000
11:48:00.029000
11:53:59.971000
12:00:00
12:06:00.029000
12:11:59.971000
12:15:00.029000
12:18:00
12:24:00.029000
12:29:59.971000
12:36:00
12:42:00.029000
12:45:00
12:47:59.971000
12:54:00
13:00:00.029000
13:05:59.971000
13:12:00
13:14:59.971000
13:18:00.029000
13:23:59.971000
13:30:00
13:36:00.029000
13:41:59.971000
13:45:00.029000
13:48:00
13:54:00.029000
13:59:59.971000
14:06:00
14:12:00.029000
14:15:00
14:17:59.971000
14:24:00
14:30:00.029000
14:35:59.971000
14:42:00
14:44:59.971000
14:48:00.029000
14:53:59.971000
15:00:00
15:06:00.029000
15:11:59.971000
15:15:00.029000
15:18:00
15:24:00.029000
15:29:59.971000
15:36:00
15:42:00.029000
15:45:00
15:47:59.971000
15:54:00
16:00:00.029000
16:05:59.971000
16:12:00
16:14:59.971000
16:18:00.029000
16:23:59.971000
16:30:00
16:36:00.029000
16:41:59.971000
16:45:00.029000
16:48:00
16:54:00.029000
16:59:59.971000
17:06:00
17:12:00.029000
17:15:00
17:17:59.971000
17:24:00
17:30:00.029000
17:35:59.971000
17:42:00
17:44:59.971000
17:48:00.029000
17:53:59.971000
18:00:00
18:06:00.029000
18:11:59.971000
18:15:00.029000
18:18:00
18:24:00.029000
18:29:59.971000
18:36:00
18:42:00.029000
18:45:00
18:47:59.971000
18:54:00
19:00:00.029000
19:05:59.971000
19:12:00
19:14:59.971000
19:18:00.029000
19:23:59.971000
19:30:00
19:36:00.029000
19:41:59.971000
19:45:00.029000
19:48:00
19:54:00.029000
19:59:59.971000
20:06:00
20:12:00.029000
20:15:00
20:17:59.971000
20:24:00
20:30:00.029000
20:35:59.971000
20:42:00
20:44:59.971000
20:48:00.029000
20:53:59.971000
21:00:00
21:06:00.029000
21:11:59.971000
21:15:00.029000
21:18:00
21:24:00.029000
21:29:59.971000
21:36:00
21:42:00.029000
21:45:00
21:47:59.971000
21:54:00
22:00:00.029000
22:05:59.971000
22:12:00
22:14:59.971000
22:18:00.029000
22:23:59.971000
22:30:00
22:36:00.029000
22:41:59.971000
22:45:00.029000
22:48:00
22:54:00.029000
22:59:59.971000
23:06:00
23:12:00.029000
23:15:00
23:17:59.971000
23:24:00
23:30:00.029000
23:35:59.971000
23:42:00
23:44:59.971000
23:48:00.029000
23:53:59.971000