Spreadsheet: 785587d1656505502-sumproduct-or-sumifs-between-2-dates-excel-help-sumproduct-or-sum-ifs-between-2-dates
Sheet: excel help

Employee Name | Team | Date | Activity Name | Activity Start | Activity End | Duration Seconds | Paid |  | 2022-06-27 00:00:00 | Apple Picking
Aamenah [NAME], 7384 | TL Tish Holdsworth | 2022-06-27 00:00:00 | [NAME] | 08:30:00 | 08:45:00 | 900 | Y |  | 08:00:00 | 20:00:00
Aamenah [NAME], 7384 | TL Tish Holdsworth | 2022-06-27 00:00:00 | [NAME] | 08:50:00 | 09:30:00 | 2400 | Y
Aamenah [NAME], 7384 | TL Tish Holdsworth | 2022-06-28 00:00:00 | [NAME] | 08:00:00 | 08:15:00 | 900 | Y
Aamenah [NAME], 7384 | TL Tish Holdsworth | 2022-06-28 00:00:00 | [NAME] | 08:20:00 | 09:30:00 | 4200 | Y
Aamenah [NAME], 7384 | TL Tish Holdsworth | 2022-06-29 00:00:00 | [NAME] | 08:00:00 | 08:15:00 | 900 | Y |  |  |  | My attempt [NAME]
Aamenah [NAME], 7384 | TL Tish Holdsworth | 2022-06-29 00:00:00 | [NAME] | 08:20:00 | 09:30:00 | 4200 | Y |  |  |  | My attempt SumIf's
[NAME], 7111 | TL Bridie Lyons | 2022-06-27 00:00:00 | [NAME] | 09:45:00 | 11:45:00 | 7200 | Y |  |  | 114300 | Correct Answer
[NAME], 7111 | TL Bridie Lyons | 2022-06-28 00:00:00 | [NAME] | 17:15:00 | 18:00:00 | 2700 | Y
[NAME], 7111 | TL Bridie Lyons | 2022-06-28 00:00:00 | [NAME] | 18:10:00 | 19:15:00 | 3900 | Y
[NAME], 7111 | TL Bridie Lyons | 2022-06-29 00:00:00 | Apple Picking | 08:00:00 | 08:15:00 | 900 | Y
[NAME], 7111 | TL Bridie Lyons | 2022-06-29 00:00:00 | Apple Picking | 08:20:00 | 09:30:00 | 4200 | Y
[NAME], 7046 | TL Tish Holdsworth | 2022-06-27 00:00:00 | Apple Picking | 10:00:00 | 10:15:00 | 900 | Y
[NAME], 7046 | TL Tish Holdsworth | 2022-06-27 00:00:00 | Apple Picking | 10:20:00 | 11:00:00 | 2400 | Y
[NAME], 7046 | TL Tish Holdsworth | 2022-06-28 00:00:00 | Apple Picking | 11:00:00 | 11:15:00 | 900 | Y
[NAME], 7046 | TL Tish Holdsworth | 2022-06-28 00:00:00 | Apple Picking | 11:20:00 | 12:00:00 | 2400 | Y
[NAME], 7046 | TL Tish Holdsworth | 2022-06-29 00:00:00 | Apple Picking | 10:00:00 | 10:15:00 | 900 | Y
[NAME], 7046 | TL Tish Holdsworth | 2022-06-29 00:00:00 | Apple Picking | 10:20:00 | 11:00:00 | 2400 | Y
[NAME], 7044 | TL [NAME] | 2022-06-27 00:00:00 | [NAME] | 08:00:00 | 08:45:00 | 2700 | Y
[NAME], 7044 | TL [NAME] | 2022-06-27 00:00:00 | [NAME] | 08:55:00 | 10:00:00 | 3900 | Y
[NAME], 7044 | TL [NAME] | 2022-06-28 00:00:00 | [NAME] | 08:00:00 | 08:45:00 | 2700 | Y
[NAME], 7044 | TL [NAME] | 2022-06-28 00:00:00 | [NAME] | 08:55:00 | 10:45:00 | 6600 | Y
[NAME], 7044 | TL [NAME] | 2022-06-28 00:00:00 | [NAME] | 11:00:00 | 13:00:00 | 7200 | Y
[NAME], 7044 | TL [NAME] | 2022-06-28 00:00:00 | [NAME] | 13:15:00 | 16:00:00 | 9900 | Y
[NAME], 7955 | TL [NAME] | 2022-06-27 00:00:00 | [NAME] | 17:30:00 | 17:45:00 | 900 | Y
[NAME], 7955 | TL [NAME] | 2022-06-27 00:00:00 | Apple Picking | 17:50:00 | 19:00:00 | 4200 | Y
[NAME], 7955 | TL [NAME] | 2022-06-29 00:00:00 | Apple Picking | 08:00:00 | 08:45:00 | 2700 | Y
[NAME], 7955 | TL [NAME] | 2022-06-29 00:00:00 | Apple Picking | 08:55:00 | 10:00:00 | 3900 | Y
[NAME], 8622 | TL Nasser Ramzan | 2022-06-27 00:00:00 | Apple Picking | 17:00:00 | 17:30:00 | 1800 | Y
[NAME], 8622 | TL Nasser Ramzan | 2022-06-28 00:00:00 | Apple Picking | 09:00:00 | 09:15:00 | 900 | Y
[NAME], 8622 | TL Nasser Ramzan | 2022-06-28 00:00:00 | Apple Picking | 09:20:00 | 10:00:00 | 2400 | Y
[NAME], 7777 | TL Joel Buttery | 2022-06-27 00:00:00 | Apple Picking | 08:00:00 | 09:45:00 | 6300 | Y
[NAME], 7777 | TL Joel Buttery | 2022-06-27 00:00:00 | Apple Picking | 10:05:00 | 12:00:00 | 6900 | Y
[NAME], 7619 | TL [NAME] | 2022-06-27 00:00:00 | Apple Picking | 09:30:00 | 10:15:00 | 2700 | Y
[NAME], 7619 | TL [NAME] | 2022-06-27 00:00:00 | Apple Picking | 10:25:00 | 11:30:00 | 3900 | Y
[NAME], 7619 | TL [NAME] | 2022-06-29 00:00:00 | Apple Picking | 09:30:00 | 10:15:00 | 2700 | Y
[NAME], 7619 | TL [NAME] | 2022-06-29 00:00:00 | Apple Picking | 10:25:00 | 11:30:00 | 3900 | Y
[NAME], 7155 | TL [NAME] | 2022-06-27 00:00:00 | Apple Picking | 08:00:00 | 08:15:00 | 900 | Y
[NAME], 7155 | TL [NAME] | 2022-06-27 00:00:00 | Apple Picking | 08:20:00 | 09:45:00 | 5100 | Y
[NAME], 7155 | TL [NAME] | 2022-06-29 00:00:00 | [NAME] | 08:00:00 | 08:15:00 | 900 | Y
[NAME], 7155 | TL [NAME] | 2022-06-29 00:00:00 | [NAME] | 08:20:00 | 09:00:00 | 2400 | Y
[NAME], 7104 | [NAME] Jerome | 2022-06-29 00:00:00 | [NAME] | 08:00:00 | 08:30:00 | 1800 | Y
[NAME], 7104 | [NAME] Jerome | 2022-06-29 00:00:00 | [NAME] | 16:00:00 | 16:30:00 | 1800 | Y
[NAME], 8193 | TL Benjamin Leister | 2022-06-28 00:00:00 | Apple Picking | 19:00:00 | 19:15:00 | 900 | Y
[NAME], 8193 | TL Benjamin Leister | 2022-06-28 00:00:00 | Apple Picking | 19:20:00 | 20:00:00 | 2400 | Y
[NAME], 7289 | TL Joel Buttery | 2022-06-27 00:00:00 | Apple Picking | 08:00:00 | 09:45:00 | 6300 | Y
[NAME], 7289 | TL Joel Buttery | 2022-06-27 00:00:00 | Apple Picking | 10:05:00 | 12:30:00 | 8700 | Y
[NAME], 7154 | TL Megan/Helen | 2022-06-27 00:00:00 | [NAME] | 18:00:00 | 18:15:00 | 900 | Y
[NAME], 7154 | TL Megan/Helen | 2022-06-27 00:00:00 | [NAME] | 18:20:00 | 19:00:00 | 2400 | Y
[NAME], 7154 | TL Megan/Helen | 2022-06-28 00:00:00 | [NAME] | 08:00:00 | 08:45:00 | 2700 | Y
[NAME], 7154 | TL Megan/Helen | 2022-06-28 00:00:00 | [NAME] | 08:55:00 | 10:00:00 | 3900 | Y
[NAME], 7154 | TL Megan/Helen | 2022-06-28 00:00:00 | Apple Picking | 11:00:00 | 11:50:00 | 3000 | Y
[NAME], 7154 | TL Megan/Helen | 2022-06-28 00:00:00 | Apple Picking | 12:00:00 | 13:00:00 | 3600 | Y
[NAME], 7147 | TL Nicola Senior | 2022-06-27 00:00:00 | Apple Picking | 11:00:00 | 12:30:00 | 5400 | Y
[NAME], 7147 | TL Nicola Senior | 2022-06-27 00:00:00 | Apple Picking | 12:45:00 | 14:00:00 | 4500 | Y
[NAME], 7147 | TL Nicola Senior | 2022-06-29 00:00:00 | [NAME] | 08:00:00 | 08:30:00 | 1800 | Y
[NAME], 7216 | TL [NAME] | 2022-06-28 00:00:00 | [NAME] | 14:30:00 | 15:47:38 | 4658 | Y
[NAME], 7216 | TL [NAME] | 2022-06-28 00:00:00 | [NAME] | 15:47:38 | 16:00:00 | 742 | Y
[NAME], 7216 | TL [NAME] | 2022-06-28 00:00:00 | [NAME] | 16:15:00 | 17:30:00 | 4500 | Y
[NAME], 7834 | TL Harpal Gill | 2022-06-27 00:00:00 | Apple Picking | 09:00:00 | 09:15:00 | 900 | Y
[NAME], 7834 | TL Harpal Gill | 2022-06-27 00:00:00 | Apple Picking | 09:20:00 | 10:00:00 | 2400 | Y
[NAME], 8043 | TL Bridie Lyons | 2022-06-27 00:00:00 | Apple Picking | 08:00:00 | 09:30:00 | 5400 | Y
[NAME], 8043 | TL Bridie Lyons | 2022-06-27 00:00:00 | Apple Picking | 09:45:00 | 11:45:00 | 7200 | Y
[NAME], 8012 | TL Bridie Lyons | 2022-06-27 00:00:00 | [NAME] | 08:00:00 | 09:15:00 | 4500 | Y
[NAME], 8012 | TL Bridie Lyons | 2022-06-27 00:00:00 | [NAME] | 09:30:00 | 12:00:00 | 9000 | Y
[NAME], 8012 | TL Bridie Lyons | 2022-06-27 00:00:00 | [NAME] | 12:15:00 | 14:30:00 | 8100 | Y
[NAME], 8012 | TL Bridie Lyons | 2022-06-27 00:00:00 | [NAME] | 14:45:00 | 17:00:00 | 8100 | Y
[NAME], 8012 | TL Bridie Lyons | 2022-06-27 00:00:00 | Apple Picking | 17:15:00 | 20:00:00 | 9900 | Y
[NAME], 7058 | TL Joel Buttery | 2022-06-27 00:00:00 | Apple Picking | 17:00:00 | 18:30:00 | 5400 | Y
[NAME], 7058 | TL Joel Buttery | 2022-06-27 00:00:00 | Apple Picking | 18:45:00 | 20:00:00 | 4500 | Y
[NAME], 7058 | TL Joel Buttery | 2022-06-28 00:00:00 | Apple Picking | 18:15:00 | 18:30:00 | 900 | Y
[NAME], 7058 | TL Joel Buttery | 2022-06-28 00:00:00 | [NAME] | 18:35:00 | 20:00:00 | 5100 | Y
Mamoon Ashfaq, 7853 | TL [NAME] | 2022-06-27 00:00:00 | [NAME] | 09:00:00 | 09:15:00 | 900 | Y
Mamoon Ashfaq, 7853 | TL [NAME] | 2022-06-27 00:00:00 | [NAME] | 09:20:00 | 10:00:00 | 2400 | Y
Mamoon Ashfaq, 7853 | TL [NAME] | 2022-06-28 00:00:00 | [NAME] | 09:00:00 | 09:45:00 | 2700 | Y
Mamoon Ashfaq, 7853 | TL [NAME] | 2022-06-29 00:00:00 | Apple Picking | 16:15:00 | 17:00:00 | 2700 | Y
Mamoon Ashfaq, 7853 | TL [NAME] | 2022-06-29 00:00:00 | Apple Picking | 17:10:00 | 18:15:00 | 3900 | Y
[NAME], 7380 | TL Megan/Helen | 2022-06-27 00:00:00 | Apple Picking | 08:00:00 | 09:30:00 | 5400 | Y
[NAME], 7380 | TL Megan/Helen | 2022-06-27 00:00:00 | Apple Picking | 09:45:00 | 11:45:00 | 7200 | Y
[NAME], 7380 | TL Megan/Helen | 2022-06-28 00:00:00 | [NAME] | 08:00:00 | 09:30:00 | 5400 | Y
[NAME], 7380 | TL Megan/Helen | 2022-06-28 00:00:00 | [NAME] | 09:45:00 | 11:45:00 | 7200 | Y
[NAME], 7380 | TL Megan/Helen | 2022-06-29 00:00:00 | [NAME] | 08:00:00 | 09:30:00 | 5400 | Y
[NAME], 7380 | TL Megan/Helen | 2022-06-29 00:00:00 | [NAME] | 09:45:00 | 11:45:00 | 7200 | Y
[NAME], 8337 | TL Benjamin Leister | 2022-06-28 00:00:00 | Apple Picking | 09:45:00 | 10:30:00 | 2700 | Y
[NAME], 8337 | TL Benjamin Leister | 2022-06-28 00:00:00 | Apple Picking | 10:40:00 | 11:45:00 | 3900 | Y
[NAME], 8258 | TL [NAME] | 2022-06-27 00:00:00 | Apple Picking | 16:15:00 | 16:30:00 | 900 | Y
[NAME], 8258 | TL [NAME] | 2022-06-27 00:00:00 | Apple Picking | 16:35:00 | 17:15:00 | 2400 | Y
[NAME], 8258 | TL [NAME] | 2022-06-29 00:00:00 | [NAME] | 16:15:00 | 16:30:00 | 900 | Y
[NAME], 8258 | TL [NAME] | 2022-06-29 00:00:00 | [NAME] | 16:35:00 | 17:15:00 | 2400 | Y
[NAME], 8445 | TL Harpal Gill | 2022-06-27 00:00:00 | [NAME] | 09:15:00 | 09:50:00 | 2100 | Y
[NAME], 8445 | TL Harpal Gill | 2022-06-27 00:00:00 | [NAME] | 09:55:00 | 11:00:00 | 3900 | Y
[NAME], 8445 | TL Harpal Gill | 2022-06-27 00:00:00 | Apple Picking | 19:15:00 | 20:00:00 | 2700 | Y
[NAME], 8445 | TL Harpal Gill | 2022-06-28 00:00:00 | Apple Picking | 08:00:00 | 09:30:00 | 5400 | Y
[NAME], 8445 | TL Harpal Gill | 2022-06-28 00:00:00 | Apple Picking | 09:45:00 | 11:00:00 | 4500 | Y
[NAME], 8445 | TL Harpal Gill | 2022-06-28 00:00:00 | Apple Picking | 19:15:00 | 20:00:00 | 2700 | Y
[NAME], 8445 | TL Harpal Gill | 2022-06-29 00:00:00 | [NAME] | 08:00:00 | 08:45:00 | 2700 | Y
[NAME], 8445 | TL Harpal Gill | 2022-06-29 00:00:00 | [NAME] | 08:55:00 | 10:00:00 | 3900 | Y
[NAME], 8445 | TL Harpal Gill | 2022-06-29 00:00:00 | [NAME] | 18:15:00 | 18:30:00 | 900 | Y
[NAME], 8445 | TL Harpal Gill | 2022-06-29 00:00:00 | [NAME] | 18:35:00 | 20:00:00 | 5100 | Y