Spreadsheet: 109418d1306278296-matching-up-two-data-tables-based-on-time-example
Sheet: Sheet1

Test
Data Point | Date | Time | Aerosol mg/m^3 |  | P | D | I | Time | WS | kmph
1 | 2015-04-30 00:00:00 | 08:27:45 | 0.016 |  |  |  |  | 08:28:00
2 | 2015-04-30 00:00:00 | 08:28:15 | 0.005 |  | 2 | 2 | 3 | 08:31:00
3 | 2015-04-30 00:00:00 | 08:28:45 | 0.007 |  |  |  |  | 08:31:00 | HL | 0.3
4 | 2015-04-30 00:00:00 | 08:29:15 | 0.006 |  | 2 | 2 | 3 | 08:32:00
5 | 2015-04-30 00:00:00 | 08:29:45 | 0.007 |  | 1 | 4 | 2 | 08:33:00
6 | 2015-04-30 00:00:00 | 08:30:15 | 0.008 |  | 1 | 2 | 3 | 08:36:00
7 | 2015-04-30 00:00:00 | 08:30:45 | 0.009 |  |  |  |  | 08:37:00 | QW | 2.5
8 | 2015-04-30 00:00:00 | 08:31:15 | 0.011 |  |  |  |  | 08:42:00 | KB | 2.8
9 | 2015-04-30 00:00:00 | 08:31:45 | 0.007 |  | 1 | 3 | 3 | 08:47:00
10 | 2015-04-30 00:00:00 | 08:32:15 | 0.027 |  |  |  |  | 08:52:00 | QH | 0.7
11 | 2015-04-30 00:00:00 | 08:32:45 | 0.007 |  |  |  |  | 08:55:00
12 | 2015-04-30 00:00:00 | 08:33:15 | 0.008 |  |  |  |  | 08:55:00
13 | 2015-04-30 00:00:00 | 08:33:45 | 0.004 |  |  |  |  | 08:58:00 | QH | 0
14 | 2015-04-30 00:00:00 | 08:34:15 | 0.007 |  | 2 | 2 | 3 | 08:58:00
15 | 2015-04-30 00:00:00 | 08:34:45 | 0.005 |  |  |  |  | 09:07:00 | KB | 1
16 | 2015-04-30 00:00:00 | 08:35:15 | 0.007 |  |  |  |  | 09:11:00 | QW | 1.4
17 | 2015-04-30 00:00:00 | 08:35:45 | 0.006 |  | 3 | 2 | 3 | 09:15:00
18 | 2015-04-30 00:00:00 | 08:36:15 | 0.006 |  |  |  |  | 09:18:00 | HL | 5.7
19 | 2015-04-30 00:00:00 | 08:36:45 | 0.008 |  |  |  |  | 09:21:00
20 | 2015-04-30 00:00:00 | 08:37:15 | 0.005
21 | 2015-04-30 00:00:00 | 08:37:45 | 0.006
22 | 2015-04-30 00:00:00 | 08:38:15 | 0.005
23 | 2015-04-30 00:00:00 | 08:38:45 | 0.003
24 | 2015-04-30 00:00:00 | 08:39:15 | 0.003
25 | 2015-04-30 00:00:00 | 08:39:45 | 0.004
26 | 2015-04-30 00:00:00 | 08:40:15 | 0.003
27 | 2015-04-30 00:00:00 | 08:40:45 | 0.003
28 | 2015-04-30 00:00:00 | 08:41:15 | 0.003
29 | 2015-04-30 00:00:00 | 08:41:45 | 0.003
30 | 2015-04-30 00:00:00 | 08:42:15 | 0.004
31 | 2015-04-30 00:00:00 | 08:42:45 | 0.004
32 | 2015-04-30 00:00:00 | 08:43:15 | 0.005
33 | 2015-04-30 00:00:00 | 08:43:45 | 0.007
34 | 2015-04-30 00:00:00 | 08:44:15 | 0.005
35 | 2015-04-30 00:00:00 | 08:44:45 | 0.005
36 | 2015-04-30 00:00:00 | 08:45:15 | 0.008
37 | 2015-04-30 00:00:00 | 08:45:45 | 0.009
38 | 2015-04-30 00:00:00 | 08:46:15 | 0.012
39 | 2015-04-30 00:00:00 | 08:46:45 | 0.006
40 | 2015-04-30 00:00:00 | 08:47:15 | 0.004
41 | 2015-04-30 00:00:00 | 08:47:45 | 0.004
42 | 2015-04-30 00:00:00 | 08:48:15 | 0.003
43 | 2015-04-30 00:00:00 | 08:48:45 | 0.003
44 | 2015-04-30 00:00:00 | 08:49:15 | 0.003
45 | 2015-04-30 00:00:00 | 08:49:45 | 0.004
46 | 2015-04-30 00:00:00 | 08:50:15 | 0.004
47 | 2015-04-30 00:00:00 | 08:50:45 | 0.005
48 | 2015-04-30 00:00:00 | 08:51:15 | 0.008
49 | 2015-04-30 00:00:00 | 08:51:45 | 0.004
50 | 2015-04-30 00:00:00 | 08:52:15 | 0.004
51 | 2015-04-30 00:00:00 | 08:52:45 | 0.003
52 | 2015-04-30 00:00:00 | 08:53:15 | 0.003
53 | 2015-04-30 00:00:00 | 08:53:45 | 0.003
54 | 2015-04-30 00:00:00 | 08:54:15 | 0.007
55 | 2015-04-30 00:00:00 | 08:54:45 | 0.005
56 | 2015-04-30 00:00:00 | 08:55:15 | 0.004
57 | 2015-04-30 00:00:00 | 08:55:45 | 0.002
58 | 2015-04-30 00:00:00 | 08:56:15 | 0.004
59 | 2015-04-30 00:00:00 | 08:56:45 | 0.003
60 | 2015-04-30 00:00:00 | 08:57:15 | 0.003
61 | 2015-04-30 00:00:00 | 08:57:45 | 0.003
62 | 2015-04-30 00:00:00 | 08:58:15 | 0.004
63 | 2015-04-30 00:00:00 | 08:58:45 | 0.016
64 | 2015-04-30 00:00:00 | 08:59:15 | 0.004
65 | 2015-04-30 00:00:00 | 08:59:45 | 0.002
66 | 2015-04-30 00:00:00 | 09:00:15 | 0.002
67 | 2015-04-30 00:00:00 | 09:00:45 | 0.002
68 | 2015-04-30 00:00:00 | 09:01:15 | 0.003
69 | 2015-04-30 00:00:00 | 09:01:45 | 0.001
70 | 2015-04-30 00:00:00 | 09:02:15 | 0.002
71 | 2015-04-30 00:00:00 | 09:02:45 | 0.004
72 | 2015-04-30 00:00:00 | 09:03:15 | 0.005
73 | 2015-04-30 00:00:00 | 09:03:45 | 0.002
74 | 2015-04-30 00:00:00 | 09:04:15 | 0.002
75 | 2015-04-30 00:00:00 | 09:04:45 | 0.002
76 | 2015-04-30 00:00:00 | 09:05:15 | 0.002
77 | 2015-04-30 00:00:00 | 09:05:45 | 0.002
78 | 2015-04-30 00:00:00 | 09:06:15 | 0.002
79 | 2015-04-30 00:00:00 | 09:06:45 | 0.002
80 | 2015-04-30 00:00:00 | 09:07:15 | 0.003
81 | 2015-04-30 00:00:00 | 09:07:45 | 0.003
82 | 2015-04-30 00:00:00 | 09:08:15 | 0.004
83 | 2015-04-30 00:00:00 | 09:08:45 | 0.005
84 | 2015-04-30 00:00:00 | 09:09:15 | 0.003
85 | 2015-04-30 00:00:00 | 09:09:45 | 0.003
86 | 2015-04-30 00:00:00 | 09:10:15 | 0.004
87 | 2015-04-30 00:00:00 | 09:10:45 | 0.006
88 | 2015-04-30 00:00:00 | 09:11:15 | 0.005
89 | 2015-04-30 00:00:00 | 09:11:45 | 0.003
90 | 2015-04-30 00:00:00 | 09:12:15 | 0.006
91 | 2015-04-30 00:00:00 | 09:12:45 | 0.011
92 | 2015-04-30 00:00:00 | 09:13:15 | 0.006
93 | 2015-04-30 00:00:00 | 09:13:45 | 0.003
94 | 2015-04-30 00:00:00 | 09:14:15 | 0.002
95 | 2015-04-30 00:00:00 | 09:14:45 | 0.004
96 | 2015-04-30 00:00:00 | 09:15:15 | 0.012
97 | 2015-04-30 00:00:00 | 09:15:45 | 0.002
98 | 2015-04-30 00:00:00 | 09:16:15 | 0.001
99 | 2015-04-30 00:00:00 | 09:16:45 | 0.002
100 | 2015-04-30 00:00:00 | 09:17:15 | 0.002
101 | 2015-04-30 00:00:00 | 09:17:45 | 0.005
102 | 2015-04-30 00:00:00 | 09:18:15 | 0.002
103 | 2015-04-30 00:00:00 | 09:18:45 | 0.001
104 | 2015-04-30 00:00:00 | 09:19:15 | 0.002
105 | 2015-04-30 00:00:00 | 09:19:45 | 0.002
106 | 2015-04-30 00:00:00 | 09:20:15 | 0.002
107 | 2015-04-30 00:00:00 | 09:20:45 | 0.002