Spreadsheet: 87846d1287701789-converting-tic-database-to-6-second-database-six-second-challenge
Sheet: Sheet4

 |  |  |  | Desired Output
Sum of Close | Date
Time | 2010-10-21 00:00:00 |  |  | Time | Average | Comment
11:00:02 | 11211.39 |  |  | 11:00:06 | 11211 | Need the average from 11:00:00 up to but not including 11:00:06
11:00:04 | 11211.46 |  |  | 11:00:12 | 11210
11:00:06 | 11211.09 |  |  | 11:00:18 | 11210
11:00:08 | 11210.9 |  |  | 11:00:24 | 11210
11:00:10 | 11210.44 |  |  | 11:00:30 | 11211
11:00:12 | 11210.52 |  |  | 11:00:36 | 11211
11:00:15 | 11210.4 |  |  | 11:00:42 | 11210
11:00:16 | 11210.37 |  |  | 11:00:48 | 11209
11:00:18 | 11210.29 |  |  | 11:00:54 | 11210
11:00:24 | 11210.21 |  |  | 11:01:00 | 11210
11:00:28 | 11210.97 |  |  | 11:01:06 | 11210
11:00:32 | 11210.52 |  |  | 11:01:12 | 11210
11:00:36 | 11210.44 |  |  | 11:01:18 | etc
11:00:40 | 11210.14 |  |  | 11:01:24
11:00:42 | 11209.91 |  |  | 11:01:30
11:00:45 | 11209.76 |  |  | 11:01:36
11:00:46 | 11209.69 |  |  | 11:01:42
11:00:48 | 11209.53 |  |  | 11:01:48
11:00:50 | 11209.99 |  |  | 11:01:54
11:00:52 | 11210.06 |  |  | 11:02:00
11:00:54 | 11210.4 |  |  | 11:02:06
11:00:56 | 11210.48 |  |  | 11:02:12
11:00:58 | 11210.33 |  |  | 11:02:18
11:01:00 | 11210.25 |  |  | 11:02:24
11:01:04 | 11210.29 |  |  | 11:02:30
11:01:06 | 11210.37 |  |  | 11:02:36
11:01:07 | 11210.59
11:01:10 | 11210.67
11:01:12 | 11210.1
11:01:14 | 11210.48
11:01:17 | 11210.56
11:01:20 | 11210.4
11:01:22 | 11210.44
11:01:24 | 11210.48
11:01:26 | 11210.1
11:01:33 | 11209.72
11:01:36 | 11209.8
11:01:37 | 11209.65
11:01:39 | 11209.57
11:01:41 | 11209.72
11:01:45 | 11209.65
11:01:47 | 11209.57
11:01:51 | 11207.41
11:01:55 | 11207.41
11:01:57 | 11207.49
11:02:00 | 11207.57
11:02:02 | 11207.34
11:02:03 | 11207.41
11:02:05 | 11207.49
11:02:07 | 11207.34
11:02:11 | 11207.64
11:02:13 | 11207.87
11:02:15 | 11209.31
11:02:17 | 11210.33
11:02:19 | 11210.71
11:02:21 | 11210.93
11:02:25 | 11211.09
11:02:27 | 11210.97
11:02:30 | 11210.9
11:02:31 | 11210.97
11:02:33 | 11212.03
11:02:35 | 11212.64
11:02:37 | 11213.17
11:02:39 | 11213.05
11:02:41 | 11212.9
11:02:45 | 11212.71
11:02:49 | 11212.37
11:02:51 | 11212.45
11:02:55 | 11212.45
11:02:57 | 11211.54
11:02:59 | 11211.39
11:03:01 | 11211.16
11:03:02 | 11211.01
11:03:05 | 11211.09
11:03:07 | 11211.16
11:03:08 | 11210.93
11:03:11 | 11210.25
11:03:13 | 11210.14
11:03:17 | 11210.37
11:03:18 | 11210.33
11:03:21 | 11210.25
11:03:22 | 11210.03
11:03:24 | 11210.33
11:03:30 | 11210.44
11:03:36 | 11210.59
11:03:38 | 11210.56
11:03:40 | 11210.63
11:03:45 | 11210.86
11:03:50 | 11210.78
11:03:52 | 11210.93
11:03:54 | 11210.86
11:03:56 | 11210.67
11:03:58 | 11209.46
11:04:00 | 11209.42
11:04:03 | 11209.72
11:04:04 | 11209.57
11:04:06 | 11207.91
11:04:08 | 11207.76
11:04:10 | 11207.72
11:04:14 | 11207.26
11:04:16 | 11207.11
11:04:18 | 11207.34
11:04:20 | 11207.19
11:04:22 | 11206.88
11:04:24 | 11206.51
11:04:26 | 11206.43
11:04:30 | 11206.35
11:04:32 | 11206.73
11:04:34 | 11206.96
11:04:36 | 11206.66
11:04:38 | 11206.35
11:04:40 | 11206.39
11:04:42 | 11206.32
11:04:46 | 11206.2
11:04:48 | 11206.35
11:04:50 | 11206.51
11:04:52 | 11206.05
11:04:55 | 11206.05
11:04:57 | 11205.9
11:04:58 | 11205.6
11:05:02 | 11204.8
11:05:04 | 11204.65
11:05:06 | 11205.11
11:05:07 | 11205.03
11:05:09 | 11204.92
11:05:14 | 11204.99
11:05:16 | 11204.35
11:05:17 | 11203.82
11:05:19 | 11203.67
11:05:23 | 11203.74
11:05:25 | 11203.55
11:05:27 | 11203.48
11:05:31 | 11203.4
11:05:33 | 11204.69
11:05:35 | 11204.99
11:05:37 | 11205.3
11:05:39 | 11206.05
11:05:41 | 11206.54
11:05:44 | 11206.39
11:05:47 | 11205.94
11:05:51 | 11206.09
11:05:53 | 11206.32
11:05:55 | 11206.32
11:05:57 | 11206.96
11:06:01 | 11207.19
11:06:03 | 11207.68
11:06:07 | 11207.53
11:06:09 | 11207.34
11:06:11 | 11207.49
11:06:13 | 11207.3
11:06:15 | 11207.38
11:06:17 | 11207.53
11:06:19 | 11207.45
11:06:21 | 11207.11
11:06:23 | 11207.04
11:06:27 | 11206.92
11:06:31 | 11206.77
11:06:33 | 11206.39
11:06:35 | 11206.01
11:06:37 | 11205.98
11:06:39 | 11205.94
11:06:41 | 11206.24
11:06:45 | 11205.75
11:06:46 | 11205.45
11:06:49 | 11205.71
11:06:51 | 11205.75
11:06:54 | 11205.98
11:06:56 | 11206.05
11:07:05 | 11205.98
11:07:08 | 11206.24
11:07:10 | 11206.39
11:07:15 | 11206.24
11:07:20 | 11206.2
11:07:23 | 11206.58
11:07:26 | 11206.88
11:07:30 | 11206.81
11:07:34 | 11206.51
11:07:36 | 11206.58
11:07:38 | 11206.43
11:07:42 | 11206.58
11:07:44 | 11206.66
11:07:46 | 11206.77
11:07:48 | 11206.85
11:07:50 | 11206.81
11:07:52 | 11206.73
11:07:54 | 11206.77
11:07:55 | 11206.77
11:07:56 | 11206.62
11:07:58 | 11206.7
11:08:00 | 11206.73
11:08:04 | 11207.11
11:08:06 | 11206.81
11:08:08 | 11207.26
11:08:10 | 11207.04
11:08:12 | 11206.66
11:08:15 | 11206.58
11:08:18 | 11206.28
11:08:20 | 11205.75
11:08:22 | 11205.52
11:08:24 | 11205.75
11:08:26 | 11205.98
11:08:30 | 11205.75
11:08:32 | 11205.67
11:08:34 | 11205.86
11:08:36 | 11205.94
11:08:38 | 11205.79
11:08:39 | 11205.71
11:08:42 | 11205.56
11:08:46 | 11205.48
11:08:47 | 11205.9
11:08:51 | 11206.2
11:08:53 | 11206.13
11:08:54 | 11206.13
11:08:56 | 11206.43
11:08:57 | 11206.88
11:09:00 | 11207.04
11:09:02 | 11207.19
11:09:05 | 11207.41
11:09:08 | 11207.49
11:09:09 | 11207.72
11:09:11 | 11207.64
11:09:13 | 11207.57
11:09:15 | 11207.04
11:09:17 | 11207.19
11:09:19 | 11207.26
11:09:21 | 11207.23
11:09:23 | 11206.88
11:09:25 | 11206.96
11:09:27 | 11206.88
11:09:30 | 11206.96
11:09:33 | 11207.15
11:09:35 | 11205.45
11:09:37 | 11205.3
11:09:39 | 11205.07
11:09:41 | 11205.45
11:09:43 | 11205.3
11:09:46 | 11205.37
11:09:53 | 11204.65
11:09:55 | 11204.65
11:09:58 | 11203.4
11:10:00 | 11202.72
11:10:03 | 11202.87
11:10:05 | 11202.27
11:10:07 | 11202.23
11:10:09 | 11202.08
11:10:11 | 11201.89
11:10:13 | 11201.66
11:10:15 | 11201.44
11:10:17 | 11201.36
11:10:19 | 11201.21
11:10:23 | 11201.06
11:10:25 | 11200.91
11:10:27 | 11200.98
11:10:29 | 11201.25
11:10:31 | 11201.7
11:10:33 | 11201.74
11:10:34 | 11201.97
11:10:36 | 11202.08
11:10:41 | 11202.27
11:10:42 | 11202.19
11:10:45 | 11202.12
11:10:53 | 11202.53
11:10:56 | 11202.65
11:10:58 | 11202.5
11:11:02 | 11202.72
11:11:04 | 11202.91
11:11:06 | 11202.76
11:11:10 | 11202.68
11:11:12 | 11202.76
11:11:15 | 11202.84
11:11:18 | 11199.69
11:11:20 | 11198.71
11:11:22 | 11198.41
11:11:24 | 11198.64
11:11:26 | 11197.8
11:11:28 | 11197.24
11:11:31 | 11197.05
11:11:34 | 11197.61
11:11:36 | 11197.16
11:11:38 | 11197.31
11:11:40 | 11197.2
11:11:42 | 11197.05
11:11:45 | 11197.42
11:11:50 | 11197.42
11:11:52 | 11197.2
11:11:54 | 11197.12
11:11:55 | 11197.12
11:11:58 | 11196.21
11:12:00 | 11196.06
11:12:02 | 11195.83
11:12:04 | 11194.93
11:12:06 | 11194.62
11:12:10 | 11194.09
11:12:12 | 11192.32
11:12:14 | 11192.09
11:12:16 | 11191.79
11:12:17 | 11191.6
11:12:20 | 11191.41
11:12:22 | 11191.26
11:12:24 | 11191.18
11:12:26 | 11191.26
11:12:27 | 11192.88
11:12:30 | 11193.22
11:12:33 | 11193.38
11:12:38 | 11192.96
11:12:41 | 11192.66
11:12:45 | 11192.81
11:12:49 | 11192.73
11:12:53 | 11192.96
11:12:54 | 11192.96
11:12:57 | 11193.03
11:13:02 | 11192.66
11:13:03 | 11190.84
11:13:05 | 11191.14
11:13:07 | 11191.41
11:13:09 | 11191.45
11:13:11 | 11191.82
11:13:13 | 11191.52
11:13:16 | 11191.67
11:13:19 | 11192.24
11:13:21 | 11192.05
11:13:23 | 11191.98
11:13:25 | 11192.13
11:13:27 | 11192.2
11:13:30 | 11191.52
11:13:31 | 11191.22
11:13:33 | 11190.61
11:13:35 | 11190.69
11:13:37 | 11190.54
11:13:39 | 11189.4
11:13:41 | 11188.87
11:13:43 | 11188.23
11:13:45 | 11188.3
11:13:47 | 11188.23
11:13:49 | 11188.53
11:13:51 | 11188.91
11:13:53 | 11188.46
11:13:55 | 11188.46
11:13:57 | 11188.08
11:13:59 | 11188.04
11:14:01 | 11187.74
11:14:03 | 11186.6
11:14:05 | 11185.88
11:14:06 | 11185.47
11:14:09 | 11185.09
11:14:11 | 11187.43
11:14:13 | 11187.96
11:14:15 | 11188.12
11:14:18 | 11188.42
11:14:21 | 11188.49
11:14:27 | 11188.65
11:14:28 | 11188.57
11:14:30 | 11188.65
11:14:34 | 11188.08
11:14:36 | 11187.7
11:14:38 | 11187.55
11:14:43 | 11187.66
11:14:45 | 11188.15
11:14:48 | 11188
11:14:50 | 11188.08
11:14:52 | 11187.96
11:14:54 | 11187.66
11:14:55 | 11187.66
11:14:57 | 11187.43
11:14:59 | 11187.24
11:15:02 | 11187.02