Spreadsheet: 755713d1637051652-looking-for-value-of-a-cell-if-multiple-criteria-are-fullfilled-samplesheet
Sheet: Tabelle1

Employee ID | Employee | Title | Department | In | Out | Day In | Date In | Time In | Day Out | Date Out | Time Out | Deduction | Hours | Notes | Device In | Device Out
 | Employee A |  |  | 2021-11-10 07:00:00 | 2021-11-10 09:00:00 | Wednesday | 2021-11-10 00:00:00 | 07:00:00 | Wednesday | 2021-11-10 00:00:00 | 09:00:00 |  | 02:00:00 |  | TimeStation-3 | TimeStation-2
 | Employee A |  |  | 2021-11-10 09:16:00 | 2021-11-10 11:35:00 | Wednesday | 2021-11-10 00:00:00 | 09:16:00 | Wednesday | 2021-11-10 00:00:00 | 11:35:00 |  | 02:19:00 |  | TimeStation-2 | TimeStation-2
 | Employee A |  |  | 2021-11-10 11:59:00 | 2021-11-10 15:08:00 | Wednesday | 2021-11-10 00:00:00 | 11:59:00 | Wednesday | 2021-11-10 00:00:00 | 15:08:00 |  | 03:09:00 |  | TimeStation-2 | TimeStation-3
 | Employee B |  |  | 2021-11-10 07:45:00 | 2021-11-10 09:00:00 | Wednesday | 2021-11-10 00:00:00 | 07:45:00 | Wednesday | 2021-11-10 00:00:00 | 09:00:00 |  | 01:15:00 |  | TimeStation-3 | TimeStation-2
 | Employee B |  |  | 2021-11-10 09:20:00 | 2021-11-10 10:48:00 | Wednesday | 2021-11-10 00:00:00 | 09:20:00 | Wednesday | 2021-11-10 00:00:00 | 10:48:00 |  | 01:28:00 |  | TimeStation-2 | TimeStation-2
 | Employee B |  |  | 2021-11-10 10:52:00 | 2021-11-10 11:43:00 | Wednesday | 2021-11-10 00:00:00 | 10:52:00 | Wednesday | 2021-11-10 00:00:00 | 11:43:00 |  | 00:51:00 |  | TimeStation-2 | TimeStation-2
 | Employee B |  |  | 2021-11-10 11:47:00 | 2021-11-10 12:11:00 | Wednesday | 2021-11-10 00:00:00 | 11:47:00 | Wednesday | 2021-11-10 00:00:00 | 12:11:00 |  | 00:24:00 |  | TimeStation-2 | TimeStation-2
 | Employee B |  |  | 2021-11-10 12:31:00 | 2021-11-10 14:34:00 | Wednesday | 2021-11-10 00:00:00 | 12:31:00 | Wednesday | 2021-11-10 00:00:00 | 14:34:00 |  | 02:03:00 |  | TimeStation-2 | TimeStation-2
 | Employee B |  |  | 2021-11-10 14:40:00 | 2021-11-10 15:22:00 | Wednesday | 2021-11-10 00:00:00 | 14:40:00 | Wednesday | 2021-11-10 00:00:00 | 15:22:00 |  | 00:42:00 |  | TimeStation-2 | TimeStation-2
 | Employee B |  |  | 2021-11-10 15:28:00 | 2021-11-10 15:50:00 | Wednesday | 2021-11-10 00:00:00 | 15:28:00 | Wednesday | 2021-11-10 00:00:00 | 15:50:00 |  | 00:22:00 |  | TimeStation-2 | TimeStation-2
 | Employee B |  |  | 2021-11-10 15:53:00 | 2021-11-10 16:02:00 | Wednesday | 2021-11-10 00:00:00 | 15:53:00 | Wednesday | 2021-11-10 00:00:00 | 16:02:00 |  | 00:09:00 |  | TimeStation-2 | TimeStation-3
 | Employee C |  |  | 2021-11-10 06:24:00 | 2021-11-10 09:00:00 | Wednesday | 2021-11-10 00:00:00 | 06:24:00 | Wednesday | 2021-11-10 00:00:00 | 09:00:00 |  | 02:36:00 |  | TimeStation-3 | TimeStation-2
 | Employee C |  |  | 2021-11-10 09:20:00 | 2021-11-10 12:00:00 | Wednesday | 2021-11-10 00:00:00 | 09:20:00 | Wednesday | 2021-11-10 00:00:00 | 12:00:00 |  | 02:40:00 |  | TimeStation-2 | TimeStation-2
 | Employee C |  |  | 2021-11-10 12:31:00 | 2021-11-10 14:38:00 | Wednesday | 2021-11-10 00:00:00 | 12:31:00 | Wednesday | 2021-11-10 00:00:00 | 14:38:00 |  | 02:07:00 |  | TimeStation-2 | TimeStation-3
 | Employee D |  |  | 2021-11-10 08:40:00 | 2021-11-10 08:49:00 | Wednesday | 2021-11-10 00:00:00 | 08:40:00 | Wednesday | 2021-11-10 00:00:00 | 08:49:00 |  | 00:09:00 |  | TimeStation-3 | TimeStation-2
 | Employee D |  |  | 2021-11-10 08:52:00 | 2021-11-10 09:20:00 | Wednesday | 2021-11-10 00:00:00 | 08:52:00 | Wednesday | 2021-11-10 00:00:00 | 09:20:00 |  | 00:28:00 |  | TimeStation-2 | TimeStation-2
 | Employee D |  |  | 2021-11-10 09:23:00 | 2021-11-10 12:05:00 | Wednesday | 2021-11-10 00:00:00 | 09:23:00 | Wednesday | 2021-11-10 00:00:00 | 12:05:00 |  | 02:42:00 |  | TimeStation-2 | TimeStation-2
 | Employee D |  |  | 2021-11-10 12:09:00 | 2021-11-10 14:04:00 | Wednesday | 2021-11-10 00:00:00 | 12:09:00 | Wednesday | 2021-11-10 00:00:00 | 14:04:00 |  | 01:55:00 |  | TimeStation-2 | TimeStation-2
 | Employee D |  |  | 2021-11-10 14:08:00 | 2021-11-10 14:54:00 | Wednesday | 2021-11-10 00:00:00 | 14:08:00 | Wednesday | 2021-11-10 00:00:00 | 14:54:00 |  | 00:46:00 |  | TimeStation-2 | TimeStation-2
 | Employee D |  |  | 2021-11-10 14:57:00 | 2021-11-10 16:04:00 | Wednesday | 2021-11-10 00:00:00 | 14:57:00 | Wednesday | 2021-11-10 00:00:00 | 16:04:00 |  | 01:07:00 |  | TimeStation-2 | TimeStation-2
 | Employee D |  |  | 2021-11-10 16:08:00 | 2021-11-10 17:22:00 | Wednesday | 2021-11-10 00:00:00 | 16:08:00 | Wednesday | 2021-11-10 00:00:00 | 17:22:00 |  | 01:14:00 |  | TimeStation-2 | TimeStation-3