Spreadsheet: 113347d1309280323-solved-match-multiple-columns-across-multiple-sheets-return-true-if-match-found-match
Sheet: OQ Log

oqdate | oqlogtime | roundedoqlogtime | Rounded Difference>15 minutes | oqtherapist name
2010-03-22 00:00:00 | 13:32:10.982000 |  |  | [NAME]
2010-04-02 00:00:00 | 10:22:27.005000 |  |  | bill
2010-04-05 00:00:00 | 11:15:10.973000 |  |  | [NAME]
2010-07-06 00:00:00 | 13:11:44.016000 |  |  | [NAME]
2010-07-15 00:00:00 | 08:05:35.030000 |  |  | jane
2010-09-08 00:00:00 | 15:13:10.992000 |  |  | [NAME]
2010-09-27 00:00:00 | 15:12:16.042000 |  |  | bill
2010-09-28 00:00:00 | 08:51:01.987000 |  |  | [NAME]
2010-10-06 00:00:00 | 13:08:25.987000 |  |  | [NAME]
2010-10-11 00:00:00 | 13:30:55.037000 |  |  | jane
2010-10-11 00:00:00 | 14:38:08.966000 |  |  | [NAME]
2010-10-11 00:00:00 | 15:28:02.035000 |  |  | bill
2010-10-20 00:00:00 | 08:27:49.997000 |  |  | [NAME]
2010-10-25 00:00:00 | 11:20:43.008000 |  |  | [NAME]
2010-11-01 00:00:00 | 08:39:51.005000 |  |  | jane
2010-11-30 00:00:00 | 09:25:31.008000 |  |  | [NAME]
2010-12-01 00:00:00 | 14:41:51.965000 |  |  | bill
2010-01-04 00:00:00 | 11:11:34.973000 |  |  | [NAME]
2010-01-05 00:00:00 | 08:08:47.962000 |  |  | [NAME]
2010-01-05 00:00:00 | 08:12:19.987000 |  |  | jane
2010-01-05 00:00:00 | 09:00:31.968000 |  |  | [NAME]
2010-01-05 00:00:00 | 13:01:41.030000 |  |  | bill
2010-01-05 00:00:00 | 14:06:40.003000 |  |  | [NAME]
2010-01-06 00:00:00 | 11:06:41.040000 |  |  | [NAME]
2010-01-07 00:00:00 | 14:10:31.037000 |  |  | jane
2010-01-07 00:00:00 | 16:02:33.994000 |  |  | [NAME]
2010-01-11 00:00:00 | 10:07:59.981000 |  |  | bill
2010-01-12 00:00:00 | 08:09:34.963000 |  |  | [NAME]
2010-01-12 00:00:00 | 15:16:08.976000 |  |  | [NAME]
2010-01-13 00:00:00 | 10:10:13.987000 |  |  | jane
2010-01-13 00:00:00 | 12:40:00.970000 |  |  | [NAME]
2010-01-13 00:00:00 | 15:57:09.043000 |  |  | bill
2010-01-13 00:00:00 | 16:40:27.005000 |  |  | [NAME]
2010-01-14 00:00:00 | 13:58:23.981000 |  |  | [NAME]
2010-01-14 00:00:00 | 14:07:56.035000 |  |  | jane
2010-01-14 00:00:00 | 17:17:43.987000 |  |  | [NAME]
2010-01-19 00:00:00 | 08:08:21.005000 |  |  | bill
2010-01-19 00:00:00 | 09:05:08.016000 |  |  | [NAME]
2010-01-19 00:00:00 | 14:10:40.973000 |  |  | [NAME]
2010-01-19 00:00:00 | 16:18:37.008000 |  |  | jane
2010-01-20 00:00:00 | 15:53:07.987000 |  |  | [NAME]
2010-01-21 00:00:00 | 15:05:46.982000 |  |  | bill
2010-01-21 00:00:00 | 16:17:50.006000 |  |  | [NAME]
2010-01-22 00:00:00 | 16:55:46.992000 |  |  | [NAME]
2010-01-25 00:00:00 | 10:17:43.008000 |  |  | jane
2010-01-25 00:00:00 | 13:04:53.962000 |  |  | [NAME]
2010-01-25 00:00:00 | 18:06:42.019000 |  |  | bill
2010-01-26 00:00:00 | 09:06:09.965000 |  |  | [NAME]
2010-01-26 00:00:00 | 09:07:29.021000 |  |  | [NAME]
2010-01-27 00:00:00 | 12:24:09.965000 |  |  | jane
2010-01-27 00:00:00 | 16:08:29.962000 |  |  | [NAME]
2010-01-28 00:00:00 | 11:29:36.960000 |  |  | bill
2010-01-28 00:00:00 | 16:00:37.958000 |  |  | [NAME]
2010-02-01 00:00:00 | 15:09:05.011000 |  |  | [NAME]
2010-02-01 00:00:00 | 16:01:48.029000 |  |  | jane
2010-02-02 00:00:00 | 08:08:52.022000 |  |  | [NAME]
2010-02-02 00:00:00 | 08:59:58.013000 |  |  | bill
2010-02-02 00:00:00 | 14:10:02.006000 |  |  | [NAME]
2010-02-02 00:00:00 | 14:17:36.038000 |  |  | [NAME]
2010-02-02 00:00:00 | 16:12:38.966000 |  |  | jane
2010-02-03 00:00:00 | 16:03:57.024000 |  |  | [NAME]
2010-02-04 00:00:00 | 11:06:45.965000 |  |  | bill
2010-02-04 00:00:00 | 11:14:56.976000 |  |  | [NAME]
2010-02-04 00:00:00 | 17:18:16.992000 |  |  | [NAME]
2010-02-08 00:00:00 | 10:35:13.978000 |  |  | jane
2010-02-08 00:00:00 | 10:39:17.021000 |  |  | [NAME]
2010-02-08 00:00:00 | 14:03:23.962000 |  |  | bill
2010-02-08 00:00:00 | 16:01:27.034000 |  |  | [NAME]
2010-02-09 00:00:00 | 08:03:33.034000 |  |  | [NAME]
2010-02-09 00:00:00 | 14:06:27.994000 |  |  | jane
2010-02-09 00:00:00 | 14:20:37.997000 |  |  | [NAME]
2010-02-10 00:00:00 | 10:10:24.010000 |  |  | bill
2010-02-11 00:00:00 | 13:06:58.032000 |  |  | [NAME]
2010-02-11 00:00:00 | 16:05:45.974000 |  |  | [NAME]
2010-02-16 00:00:00 | 14:02:36.010000 |  |  | jane
2010-02-16 00:00:00 | 16:14:01.997000 |  |  | [NAME]
2010-02-17 00:00:00 | 10:05:01.997000 |  |  | bill
2010-02-17 00:00:00 | 16:02:00.038000 |  |  | [NAME]
2010-02-22 00:00:00 | 09:58:52.032000 |  |  | [NAME]
2010-02-22 00:00:00 | 11:05:25.958000 |  |  | jane
2010-02-22 00:00:00 | 13:01:08.976000 |  |  | [NAME]
2010-02-23 00:00:00 | 09:59:15.014000 |  |  | bill
2010-03-01 00:00:00 | 10:01:53.040000 |  |  | [NAME]
2010-03-01 00:00:00 | 13:10:41.030000 |  |  | [NAME]
2010-03-01 00:00:00 | 15:03:53.021000 |  |  | jane
2010-03-01 00:00:00 | 16:00:38.995000 |  |  | [NAME]
2010-03-02 00:00:00 | 14:13:32.995000 |  |  | bill
2010-03-08 00:00:00 | 13:11:14.035000 |  |  | [NAME]
2010-03-08 00:00:00 | 15:07:13.987000 |  |  | [NAME]
2010-03-08 00:00:00 | 16:12:15.984000 |  |  | jane
2010-03-09 00:00:00 | 08:06:17.971000 |  |  | [NAME]
2010-03-09 00:00:00 | 14:06:03.974000 |  |  | bill
2010-03-10 00:00:00 | 10:52:38.986000 |  |  | [NAME]
2010-03-10 00:00:00 | 11:06:57.974000 |  |  | [NAME]
2010-03-10 00:00:00 | 15:03:29.002000 |  |  | jane
2010-03-15 00:00:00 | 10:08:46.982000 |  |  | [NAME]
2010-03-15 00:00:00 | 11:07:49.987000 |  |  | bill
2010-03-15 00:00:00 | 13:07:57.043000 |  |  | [NAME]