Spreadsheet: 75159d1275677716-average-value-with-time-criteria-average-of-value-by-15-mins
Sheet: Sheet1

Time | Truncate to previous 0:15 | Value |  | Row Labels | Average of Value
19:39:31 | 19:30:00 | 46 |  | 1900-01-01 00:00:00 | 64
15:09:00 | 15:00:00 | 56 |  | 00:15:00 | 36.66666666666666
00:43:09 | 00:30:00 | 60 |  | 00:30:00 | 47.28571428571428
16:59:07 | 16:45:00 | 34 |  | 00:45:00 | 45.75
02:20:47 | 02:15:00 | 75 |  | 01:00:00 | 42
00:39:34 | 00:30:00 | 31 |  | 01:15:00 | 67.66666666666667
06:52:36 | 06:45:00 | 6 |  | 01:30:00 | 47.5
06:01:52 | 06:00:00 | 76 |  | 01:45:00 | 31
02:03:55 | 02:00:00 | 50 |  | 02:00:00 | 76.75
06:45:38 | 06:45:00 | 71 |  | 02:15:00 | 58
04:38:44 | 04:30:00 | 7 |  | 02:30:00 | 34.5
13:03:53 | 13:00:00 | 81 |  | 02:45:00 | 48.85714285714285
05:53:32 | 05:45:00 | 79 |  | 03:00:00 | 59
05:54:58 | 05:45:00 | 14 |  | 03:15:00 | 51
03:24:55 | 03:15:00 | 17 |  | 03:30:00 | 44
00:31:41 | 00:30:00 | 94 |  | 03:45:00 | 48.75
12:06:50 | 12:00:00 | 90 |  | 04:00:00 | 40
08:50:02 | 08:45:00 | 85 |  | 04:15:00 | 63.5
22:58:54 | 22:45:00 | 16 |  | 04:30:00 | 50.75
16:06:18 | 16:00:00 | 62 |  | 04:45:00 | 44.25
22:26:14 | 22:15:00 | 40 |  | 05:00:00 | 25.33333333333333
10:40:33 | 10:30:00 | 40 |  | 05:15:00 | 15
17:22:47 | 17:15:00 | 40 |  | 05:30:00 | 61.75
14:46:02 | 14:45:00 | 25 |  | 05:45:00 | 39.44444444444444
03:45:59 | 03:45:00 | 66 |  | 06:00:00 | 69.8
11:51:59 | 11:45:00 | 5 |  | 06:15:00 | 56.2
15:00:52 | 15:00:00 | 14 |  | 06:30:00 | 59
09:25:47 | 09:15:00 | 62 |  | 06:45:00 | 54.6
10:23:13 | 10:15:00 | 98 |  | 07:00:00 | 61.8
04:53:44 | 04:45:00 | 62 |  | 07:15:00 | 37.6
00:57:39 | 00:45:00 | 90 |  | 07:30:00 | 67
08:04:10 | 08:00:00 | 7 |  | 07:45:00 | 30.4
03:06:19 | 03:00:00 | 88 |  | 08:00:00 | 43.6
13:18:32 | 13:15:00 | 1 |  | 08:15:00 | 60.5
00:27:54 | 00:15:00 | 3 |  | 08:30:00 | 53
19:25:00 | 19:15:00 | 66 |  | 08:45:00 | 47.5
17:25:28 | 17:15:00 | 28 |  | 09:00:00 | 56.33333333333334
10:18:44 | 10:15:00 | 92 |  | 09:15:00 | 73.5
17:53:51 | 17:45:00 | 96 |  | 09:30:00 | 36.33333333333334
22:25:20 | 22:15:00 | 42 |  | 09:45:00 | 44
02:44:05 | 02:30:00 | 73 |  | 10:00:00 | 65.8
19:09:18 | 19:00:00 | 45 |  | 10:15:00 | 61.33333333333334
12:55:09 | 12:45:00 | 98 |  | 10:30:00 | 25.33333333333333
23:46:30 | 23:45:00 | 71 |  | 11:00:00 | 51.66666666666666
15:17:59 | 15:15:00 | 94 |  | 11:15:00 | 60
04:59:21 | 04:45:00 | 23 |  | 11:30:00 | 68
17:03:06 | 17:00:00 | 90 |  | 11:45:00 | 53
02:29:50 | 02:15:00 | 93 |  | 12:00:00 | 43.2
14:25:22 | 14:15:00 | 67 |  | 12:15:00 | 44
12:13:44 | 12:00:00 | 8 |  | 12:30:00 | 63.25
05:54:09 | 05:45:00 | 21 |  | 12:45:00 | 70.66666666666667
11:50:40 | 11:45:00 | 87 |  | 13:00:00 | 27.2
15:40:45 | 15:30:00 | 98 |  | 13:15:00 | 17
00:40:21 | 00:30:00 | 19 |  | 13:30:00 | 67.33333333333333
09:57:30 | 09:45:00 | 2 |  | 13:45:00 | 23.5
23:19:20 | 23:15:00 | 15 |  | 14:00:00 | 55
01:12:53 | 01:00:00 | 89 |  | 14:15:00 | 50.85714285714285
06:01:06 | 06:00:00 | 17 |  | 14:30:00 | 49.6
11:05:51 | 11:00:00 | 41 |  | 14:45:00 | 40.66666666666666
09:32:04 | 09:30:00 | 58 |  | 15:00:00 | 61.57142857142857
19:59:56 | 19:45:00 | 16 |  | 15:15:00 | 61.16666666666666
01:33:28 | 01:30:00 | 19 |  | 15:30:00 | 68.2
08:00:20 | 08:00:00 | 34 |  | 15:45:00 | 57
15:34:44 | 15:30:00 | 82 |  | 16:00:00 | 44.88888888888889
01:54:52 | 01:45:00 | 34 |  | 16:15:00 | 78
10:11:23 | 10:00:00 | 76 |  | 16:30:00 | 27.33333333333333
15:18:31 | 15:15:00 | 40 |  | 16:45:00 | 46.75
15:17:16 | 15:15:00 | 78 |  | 17:00:00 | 60
10:11:37 | 10:00:00 | 79 |  | 17:15:00 | 41.66666666666666
18:47:13 | 18:45:00 | 45 |  | 17:30:00 | 43.33333333333334
21:10:26 | 21:00:00 | 27 |  | 17:45:00 | 77.66666666666667
01:00:41 | 01:00:00 | 34 |  | 18:00:00 | 47.2
20:05:11 | 20:00:00 | 20 |  | 18:15:00 | 71.33333333333333
23:13:00 | 23:00:00 | 71 |  | 18:45:00 | 53.8
22:53:22 | 22:45:00 | 22 |  | 19:00:00 | 51
05:43:12 | 05:30:00 | 83 |  | 19:15:00 | 54.4
20:55:03 | 20:45:00 | 1 |  | 19:30:00 | 50.16666666666666
19:52:51 | 19:45:00 | 25 |  | 19:45:00 | 49.75
16:10:02 | 16:00:00 | 32 |  | 20:00:00 | 42.75
11:53:47 | 11:45:00 | 41 |  | 20:15:00 | 88
12:10:12 | 12:00:00 | 54 |  | 20:30:00 | 60.25
14:25:03 | 14:15:00 | 16 |  | 20:45:00 | 35.75
21:47:03 | 21:45:00 | 0 |  | 21:00:00 | 46.2
19:02:17 | 19:00:00 | 26 |  | 21:15:00 | 24.33333333333333
12:17:51 | 12:15:00 | 45 |  | 21:30:00 | 28
12:51:37 | 12:45:00 | 84 |  | 21:45:00 | 27.8
11:16:52 | 11:15:00 | 8 |  | 22:00:00 | 59
05:07:02 | 05:00:00 | 57 |  | 22:15:00 | 54.66666666666666
11:20:26 | 11:15:00 | 93 |  | 22:45:00 | 26.85714285714286
01:36:01 | 01:30:00 | 76 |  | 23:00:00 | 46
17:28:25 | 17:15:00 | 44 |  | 23:15:00 | 39.5
14:15:14 | 14:15:00 | 4 |  | 23:30:00 | 46.33333333333334
06:04:20 | 06:00:00 | 100 |  | 23:45:00 | 46.66666666666666
14:41:10 | 14:30:00 | 98 |  | (blank)
03:02:51 | 03:00:00 | 25 |  | Grand Total | 49.92708333333334
12:29:04 | 12:15:00 | 84
19:35:28 | 19:30:00 | 62
22:47:17 | 22:45:00 | 9
11:51:05 | 11:45:00 | 88
06:38:18 | 06:30:00 | 53
21:45:38 | 21:45:00 | 20
21:39:15 | 21:30:00 | 3
10:33:16 | 10:30:00 | 6
16:10:01 | 16:00:00 | 2
16:13:39 | 16:00:00 | 97
22:59:31 | 22:45:00 | 17
14:15:17 | 14:15:00 | 43
14:13:52 | 14:00:00 | 47
12:30:03 | 12:30:00 | 51
05:57:28 | 05:45:00 | 67
21:35:37 | 21:30:00 | 43
01:24:33 | 01:15:00 | 57
02:32:24 | 02:30:00 | 15
18:14:08 | 18:00:00 | 93
23:38:06 | 23:30:00 | 45
07:05:59 | 07:00:00 | 94
13:02:02 | 13:00:00 | 44
19:47:13 | 19:45:00 | 98
02:10:22 | 02:00:00 | 77
12:32:21 | 12:30:00 | 31
10:13:35 | 10:00:00 | 75
08:59:23 | 08:45:00 | 25
13:03:07 | 13:00:00 | 6
15:36:11 | 15:30:00 | 64
07:25:30 | 07:15:00 | 100
03:40:07 | 03:30:00 | 64
21:23:32 | 21:15:00 | 36
12:13:00 | 12:00:00 | 23
10:42:12 | 10:30:00 | 30
00:11:19 | 1900-01-01 00:00:00 | 67
05:30:10 | 05:30:00 | 78
02:45:55 | 02:45:00 | 63
22:23:23 | 22:15:00 | 82
20:59:54 | 20:45:00 | 21
05:02:59 | 05:00:00 | 16
17:22:54 | 17:15:00 | 82
03:17:57 | 03:15:00 | 5
04:57:11 | 04:45:00 | 87
18:10:04 | 18:00:00 | 11
19:22:00 | 19:15:00 | 0
20:42:38 | 20:30:00 | 94
10:16:17 | 10:15:00 | 7
12:47:48 | 12:45:00 | 30
11:04:35 | 11:00:00 | 78
07:52:15 | 07:45:00 | 21
07:23:58 | 07:15:00 | 21
14:26:11 | 14:15:00 | 77
00:31:09 | 00:30:00 | 88
06:27:30 | 06:15:00 | 27
15:17:25 | 15:15:00 | 47
17:38:15 | 17:30:00 | 39
02:38:06 | 02:30:00 | 17
19:04:34 | 19:00:00 | 78
09:02:44 | 09:00:00 | 35
03:59:46 | 03:45:00 | 26
01:03:58 | 01:00:00 | 3
09:51:57 | 09:45:00 | 74
16:48:32 | 16:45:00 | 22
09:52:12 | 09:45:00 | 57
03:19:05 | 03:15:00 | 19
00:38:28 | 00:30:00 | 37
05:34:23 | 05:30:00 | 1
00:54:06 | 00:45:00 | 46
06:13:33 | 06:00:00 | 100
21:02:39 | 21:00:00 | 75
11:14:10 | 11:00:00 | 41
04:06:03 | 04:00:00 | 0
04:42:00 | 04:30:00 | 92
23:05:51 | 23:00:00 | 21
08:46:13 | 08:45:00 | 27
06:57:41 | 06:45:00 | 69
09:22:32 | 09:15:00 | 85
18:09:09 | 18:00:00 | 100
11:56:19 | 11:45:00 | 44
17:25:03 | 17:15:00 | 30
08:49:42 | 08:45:00 | 55
16:46:32 | 16:45:00 | 88
09:30:23 | 09:30:00 | 35
21:56:12 | 21:45:00 | 8
15:10:43 | 15:00:00 | 97
07:02:00 | 07:00:00 | 94
10:15:26 | 10:15:00 | 11
16:27:58 | 16:15:00 | 58
19:33:15 | 19:30:00 | 64
19:31:21 | 19:30:00 | 56
08:15:15 | 08:15:00 | 24
02:54:48 | 02:45:00 | 38
19:06:33 | 19:00:00 | 10
13:11:26 | 13:00:00 | 2
00:21:00 | 00:15:00 | 58
14:09:10 | 14:00:00 | 79
21:09:44 | 21:00:00 | 79
09:11:40 | 09:00:00 | 92
04:25:24 | 04:15:00 | 89
11:02:21 | 11:00:00 | 6
13:57:59 | 13:45:00 | 34
12:32:47 | 12:30:00 | 98
16:13:12 | 16:00:00 | 63
11:52:11 | 11:45:00 | 53
17:10:16 | 17:00:00 | 94
19:59:27 | 19:45:00 | 60
15:46:26 | 15:45:00 | 57
00:50:30 | 00:45:00 | 46
01:52:52 | 01:45:00 | 28
07:56:12 | 07:45:00 | 28
17:41:49 | 17:30:00 | 84
15:14:50 | 15:00:00 | 95
16:17:18 | 16:15:00 | 98
12:22:21 | 12:15:00 | 43
07:34:10 | 07:30:00 | 25
17:59:23 | 17:45:00 | 65
19:25:31 | 19:15:00 | 99
06:19:32 | 06:15:00 | 36
18:48:39 | 18:45:00 | 58
01:21:09 | 01:15:00 | 100
08:57:08 | 08:45:00 | 32
17:57:28 | 17:45:00 | 72
06:55:26 | 06:45:00 | 79
16:32:01 | 16:30:00 | 5
02:48:29 | 02:45:00 | 0
20:54:40 | 20:45:00 | 68
02:18:23 | 02:15:00 | 6
07:40:57 | 07:30:00 | 68
22:55:57 | 22:45:00 | 23
00:03:54 | 1900-01-01 00:00:00 | 37
05:57:10 | 05:45:00 | 19
03:06:49 | 03:00:00 | 93
13:38:24 | 13:30:00 | 64
07:28:15 | 07:15:00 | 21
04:59:52 | 04:45:00 | 5
15:17:58 | 15:15:00 | 23
02:58:46 | 02:45:00 | 29
14:50:49 | 14:45:00 | 20
17:19:35 | 17:15:00 | 26
16:02:35 | 16:00:00 | 28
08:14:00 | 08:00:00 | 28
05:47:30 | 05:45:00 | 10
03:09:36 | 03:00:00 | 10
20:28:54 | 20:15:00 | 88
19:13:59 | 19:00:00 | 48
11:12:26 | 11:00:00 | 59
20:30:37 | 20:30:00 | 46
05:05:16 | 05:00:00 | 3
00:38:06 | 00:30:00 | 2
07:06:49 | 07:00:00 | 30
13:39:47 | 13:30:00 | 49
20:36:22 | 20:30:00 | 7
18:17:21 | 18:15:00 | 80
02:47:14 | 02:45:00 | 87
06:00:19 | 06:00:00 | 56
21:50:00 | 21:45:00 | 27
00:22:39 | 00:15:00 | 10
14:27:48 | 14:15:00 | 90
01:16:41 | 01:15:00 | 46
00:18:54 | 00:15:00 | 60
07:23:50 | 07:15:00 | 37
08:11:53 | 08:00:00 | 67
09:37:08 | 09:30:00 | 16
07:17:16 | 07:15:00 | 9
07:15:00 | 07:00:00 | 21
20:10:51 | 20:00:00 | 73
21:03:49 | 21:00:00 | 7
00:58:48 | 00:45:00 | 1
17:37:45 | 17:30:00 | 7
16:55:57 | 16:45:00 | 43
20:58:15 | 20:45:00 | 53
21:32:47 | 21:30:00 | 38
09:53:07 | 09:45:00 | 45
06:47:16 | 06:45:00 | 48
18:28:12 | 18:15:00 | 85
03:33:08 | 03:30:00 | 3
16:32:52 | 16:30:00 | 40
11:23:40 | 11:15:00 | 58
16:08:45 | 16:00:00 | 15
05:47:12 | 05:45:00 | 71
08:22:37 | 08:15:00 | 97
19:37:06 | 19:30:00 | 18
22:51:48 | 22:45:00 | 86
18:30:00 | 18:15:00 | 72
13:10:26 | 13:00:00 | 3
07:46:40 | 07:45:00 | 43
10:05:19 | 10:00:00 | 80
12:30:20 | 12:30:00 | 73
11:42:01 | 11:30:00 | 68
02:56:53 | 02:45:00 | 51
19:43:42 | 19:30:00 | 55
04:01:11 | 04:00:00 | 80
14:24:34 | 14:15:00 | 59
06:31:54 | 06:30:00 | 30
14:37:59 | 14:30:00 | 37
19:19:14 | 19:15:00 | 94
03:24:42 | 03:15:00 | 88
02:10:53 | 02:00:00 | 97
23:22:24 | 23:15:00 | 64
16:08:23 | 16:00:00 | 58
18:48:45 | 18:45:00 | 48
18:09:11 | 18:00:00 | 14
08:31:18 | 08:30:00 | 53
07:38:50 | 07:30:00 | 65
20:14:45 | 20:00:00 | 72
02:48:59 | 02:45:00 | 74
22:13:11 | 22:00:00 | 69
05:54:04 | 05:45:00 | 29
21:23:30 | 21:15:00 | 1
07:13:18 | 07:00:00 | 70
05:19:26 | 05:15:00 | 15
14:38:57 | 14:30:00 | 15
22:08:14 | 22:00:00 | 49
12:27:45 | 12:15:00 | 38
07:33:12 | 07:30:00 | 54
06:26:36 | 06:15:00 | 38
15:11:26 | 15:00:00 | 66
11:15:44 | 11:15:00 | 88
18:45:32 | 18:45:00 | 55
03:46:49 | 03:45:00 | 12
00:12:01 | 1900-01-01 00:00:00 | 91
15:31:20 | 15:30:00 | 0
17:02:24 | 17:00:00 | 53
03:29:28 | 03:15:00 | 96
07:54:57 | 07:45:00 | 56
23:33:31 | 23:30:00 | 41
03:40:47 | 03:30:00 | 65
23:49:46 | 23:45:00 | 4
05:43:13 | 05:30:00 | 85
00:27:49 | 00:15:00 | 14
19:27:44 | 19:15:00 | 13
08:08:27 | 08:00:00 | 82
14:09:08 | 14:00:00 | 39
04:19:33 | 04:15:00 | 38
09:54:39 | 09:45:00 | 42
09:05:23 | 09:00:00 | 42
03:08:59 | 03:00:00 | 79
03:26:02 | 03:15:00 | 81
18:08:59 | 18:00:00 | 18
18:55:38 | 18:45:00 | 63
04:42:47 | 04:30:00 | 77
10:15:04 | 10:15:00 | 65
06:24:19 | 06:15:00 | 97
20:14:44 | 20:00:00 | 6
23:44:50 | 23:30:00 | 53
03:52:20 | 03:45:00 | 91
14:35:51 | 14:30:00 | 53
23:51:56 | 23:45:00 | 65
10:12:56 | 10:00:00 | 19
11:04:37 | 11:00:00 | 85
15:38:46 | 15:30:00 | 97
10:22:39 | 10:15:00 | 95
06:25:12 | 06:15:00 | 83
08:59:41 | 08:45:00 | 61
21:16:14 | 21:15:00 | 36
17:09:27 | 17:00:00 | 3
00:05:25 | 1900-01-01 00:00:00 | 81
22:56:35 | 22:45:00 | 15
00:11:20 | 1900-01-01 00:00:00 | 44
21:53:44 | 21:45:00 | 84
05:51:34 | 05:45:00 | 45
07:33:10 | 07:30:00 | 96
00:20:00 | 00:15:00 | 75
12:15:16 | 12:15:00 | 10
16:00:27 | 16:00:00 | 47
18:16:17 | 18:15:00 | 28
18:17:54 | 18:15:00 | 95
02:13:26 | 02:00:00 | 83
04:31:05 | 04:30:00 | 27
15:08:28 | 15:00:00 | 8
12:12:01 | 12:00:00 | 41
15:16:54 | 15:15:00 | 85
14:50:46 | 14:45:00 | 77
11:25:17 | 11:15:00 | 53
15:12:32 | 15:00:00 | 95
14:37:21 | 14:30:00 | 45
19:12:51 | 19:00:00 | 91
07:34:08 | 07:30:00 | 94
13:23:11 | 13:15:00 | 33
20:40:30 | 20:30:00 | 94
07:54:39 | 07:45:00 | 4
13:33:35 | 13:30:00 | 89
13:53:17 | 13:45:00 | 13
18:18:45 | 18:15:00 | 68
02:44:54 | 02:30:00 | 33
06:30:35 | 06:30:00 | 94
16:42:43 | 16:30:00 | 37
19:03:39 | 19:00:00 | 59
21:01:09 | 21:00:00 | 43