Spreadsheet: 678798d1590067273-sumproduct-vlookup-combined-help-needed-oee-file-sample
Sheet: data

Date / Day | Shifts | OLIVIA      T2 (hh:[NAME]) |  |  |  |  | OLIVIA      T1 (hh:[NAME]) |  |  |  |  | 103   T 4 (hh:[NAME]) |  |  |  |  | 104 T 3 (hh:[NAME]) |  |  |  |  | Diverter |  |  |  |  | Manual  1 |  |  |  |  | Manual  2 |  |  |  |  | Manual  3
 |  | start | stop | staff | hours | manhours | start | stop | staff | hours | manhours | start | stop | staff | hours | manhours | start | stop | staff | hours | manhours | start | stop | staff | hours | manhours | start | stop | staff | hours | manhours | start | stop | staff | hours | manhours | start | stop | staff | hours | manhours
2020-05-01 00:00:00 | Earlies | 10:13:00 | 14:00:00 | 11 |  |  | 10:13:00 | 14:00:00 | 11 |  |  | 10:13:00 | 14:00:00 | 11 |  |  | 10:13:00 | 14:00:00 | 11 |  |  | 10:13:00 | 14:00:00 | 11 |  |  | 10:13:00 | 14:00:00 | 11 |  |  | 10:13:00 | 14:00:00 | 11 |  |  | 10:13:00 | 14:00:00 | 11
2020-05-01 00:00:00 | Lates | 10:13:00 | 14:00:00 | 10 |  |  | 10:13:00 | 14:00:00 | 10 |  |  | 10:13:00 | 14:00:00 | 10 |  |  | 10:13:00 | 14:00:00 | 10 |  |  | 10:13:00 | 14:00:00 | 10 |  |  | 10:13:00 | 14:00:00 | 10 |  |  | 10:13:00 | 14:00:00 | 10 |  |  | 10:13:00 | 14:00:00 | 10
2020-05-01 00:00:00 | Lates | 06:15:00 | 18:45:00 | 10 |  |  | 06:15:00 | 18:45:00 | 10 |  |  | 06:15:00 | 18:45:00 | 10 |  |  | 06:15:00 | 18:45:00 | 10 |  |  | 06:15:00 | 18:45:00 | 10 |  |  | 06:15:00 | 18:45:00 | 10 |  |  | 06:15:00 | 18:45:00 | 10 |  |  | 06:15:00 | 18:45:00 | 10
2020-05-01 00:00:00 | Nights | 04:03:00 | 06:00:00 | 10 |  |  | 04:03:00 | 06:00:00 | 10 |  |  | 04:03:00 | 06:00:00 | 10 |  |  | 04:03:00 | 06:00:00 | 10 |  |  | 04:03:00 | 06:00:00 | 10 |  |  | 04:03:00 | 06:00:00 | 10 |  |  | 04:03:00 | 06:00:00 | 10 |  |  | 04:03:00 | 06:00:00 | 10
2020-05-01 00:00:00 | Nights | 01:00:00 | 05:30:00 | 10 |  |  | 01:00:00 | 05:30:00 | 10 |  |  | 01:00:00 | 05:30:00 | 10 |  |  | 01:00:00 | 05:30:00 | 10 |  |  | 01:00:00 | 05:30:00 | 10 |  |  | 01:00:00 | 05:30:00 | 10 |  |  | 01:00:00 | 05:30:00 | 10 |  |  | 01:00:00 | 05:30:00 | 10
2020-05-02 00:00:00 | Earlies | 10:13:00 | 14:00:00 | 11 |  |  | 10:13:00 | 14:00:00 | 11 |  |  | 10:13:00 | 14:00:00 | 11 |  |  | 10:13:00 | 14:00:00 | 11 |  |  | 10:13:00 | 14:00:00 | 11 |  |  | 10:13:00 | 14:00:00 | 11 |  |  | 10:13:00 | 14:00:00 | 11 |  |  | 10:13:00 | 14:00:00 | 11
2020-05-02 00:00:00 | Lates | 10:13:00 | 14:00:00 | 10 |  |  | 10:13:00 | 14:00:00 | 10 |  |  | 10:13:00 | 14:00:00 | 10 |  |  | 10:13:00 | 14:00:00 | 10 |  |  | 10:13:00 | 14:00:00 | 10 |  |  | 10:13:00 | 14:00:00 | 10 |  |  | 10:13:00 | 14:00:00 | 10 |  |  | 10:13:00 | 14:00:00 | 10
2020-05-02 00:00:00 | Lates | 06:15:00 | 18:45:00 | 10 |  |  | 06:15:00 | 18:45:00 | 10 |  |  | 06:15:00 | 18:45:00 | 10 |  |  | 06:15:00 | 18:45:00 | 10 |  |  | 06:15:00 | 18:45:00 | 10 |  |  | 06:15:00 | 18:45:00 | 10 |  |  | 06:15:00 | 18:45:00 | 10 |  |  | 06:15:00 | 18:45:00 | 10
2020-05-02 00:00:00 | Nights | 04:03:00 | 06:00:00 | 10 |  |  | 04:03:00 | 06:00:00 | 10 |  |  | 04:03:00 | 06:00:00 | 10 |  |  | 04:03:00 | 06:00:00 | 10 |  |  | 04:03:00 | 06:00:00 | 10 |  |  | 04:03:00 | 06:00:00 | 10 |  |  | 04:03:00 | 06:00:00 | 10 |  |  | 04:03:00 | 06:00:00 | 10
2020-05-02 00:00:00 | Nights | 01:00:00 | 05:30:00 | 10 |  |  | 01:00:00 | 05:30:00 | 10 |  |  | 01:00:00 | 05:30:00 | 10 |  |  | 01:00:00 | 05:30:00 | 10 |  |  | 01:00:00 | 05:30:00 | 10 |  |  | 01:00:00 | 05:30:00 | 10 |  |  | 01:00:00 | 05:30:00 | 10 |  |  | 01:00:00 | 05:30:00 | 10