Spreadsheet: 109427d1306281631-matching-up-two-data-tables-based-on-time-scratch
Sheet: Sheet1

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