Spreadsheet: 715929d1611929411-sumproduct-matching-columns-and-rows-between-two-dates-excel-help-sum-prod-between-2-dates
Sheet: Sheet1

Activity Date | Scheduled Hours | Office Dur | Productive Hours | Scheduled Paid Time | Paid Plus Lunch | Actual Sick and Absence hours | Phased Return | Bereavement (Immediate Family) | Parental Leave | Paternity | AWOL | Unpaid Leave | Unpaid Agreed Absence | Paid Leave | [NAME] | Sickness | Bereavement | COVID19 | Late | Unknown Absence Reason | [NAME] | [NAME] | Business Absence
2020-01-01 00:00:00 | 722.999997 | 722.999997 | 0 | 464.749998 | 464.749998 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-02 00:00:00 | 495.249993 | 366.399995 | 348.739589 | 445.083327 | 445.083327 | 30.083332 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30.083332 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-03 00:00:00 | 468.499985 | 331.649987 | 315.503701 | 417.833319 | 417.833319 | 22.583332 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22.583332 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-04 00:00:00 | 107.999999 | 95.999999 | 95.106817 | 107.999999 | 107.999999 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-06 00:00:00 | 537.749983 | 397.533319 | 392.317688 | 491.666653 | 491.666653 | 30.749999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.5 | 23.249999 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-07 00:00:00 | 532.999984 | 398.616656 | 394.544668 | 487.166654 | 487.166654 | 23.83333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.5 | 16.166664 | 0 | 0 | 0.166666 | 0 | 0 | 0 | 0
2020-01-08 00:00:00 | 537.999988 | 422.249992 | 422.672022 | 493.583324 | 493.583324 | 15.249998 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.499998 | 7.5 | 0 | 0.25 | 0 | 0 | 0 | 0
2020-01-09 00:00:00 | 514.249985 | 398.633319 | 397.857149 | 469.749988 | 469.749988 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.5 | 7.5 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-10 00:00:00 | 498.749979 | 361.416647 | 360.602914 | 455.083315 | 455.083315 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22.5 | 7.5 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-11 00:00:00 | 83.999998 | 71.999998 | 70.918871 | 83.999998 | 83.999998 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-13 00:00:00 | 571.749989 | 424.633324 | 373.72072 | 491.74999 | 491.74999 | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.5 | 15.5 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-14 00:00:00 | 572.166654 | 453.416654 | 393.172368 | 507.166655 | 507.166655 | 30.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 15.5 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-15 00:00:00 | 529.999996 | 385.749996 | 357.904842 | 457.249997 | 457.249997 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.5 | 7.5 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-16 00:00:00 | 548.74999 | 414.416657 | 363.778869 | 470.833324 | 470.833324 | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.5 | 15.5 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-17 00:00:00 | 509.999971 | 388.416644 | 345.444079 | 433.499974 | 433.499974 | 14.999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14.999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-18 00:00:00 | 128.249984 | 115.699991 | 113.786514 | 119.999984 | 119.999984 | 0.033332 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.033332 | 0 | 0 | 0 | 0
2020-01-20 00:00:00 | 521.749994 | 372.183328 | 373.48902 | 476.249995 | 476.249995 | 42.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40.5 | 0 | 0 | 2 | 0 | 0 | 0 | 0
2020-01-21 00:00:00 | 514.399985 | 359.949987 | 397.251886 | 468.83332 | 468.83332 | 26.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 11.25 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-22 00:00:00 | 498.499993 | 358.166662 | 364.284757 | 457.249994 | 457.249994 | 31.416665 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23.916665 | 7.5 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-23 00:00:00 | 511.749984 | 389.916652 | 393.442336 | 466.749985 | 466.749985 | 28.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 21.25 | 7.5 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-24 00:00:00 | 470.249991 | 345.749991 | 351.373938 | 428.249992 | 428.249992 | 16.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-25 00:00:00 | 95.999998 | 83.249999 | 83.829396 | 95.999998 | 95.999998 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-27 00:00:00 | 537.749993 | 341.149994 | 308.257149 | 476.499994 | 476.499994 | 33.083333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.5 | 0 | 31.583333 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-28 00:00:00 | 533.999984 | 385.566653 | 385.047158 | 472.416652 | 472.416652 | 18.249999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.25 | 10.999999 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-29 00:00:00 | 523.999992 | 358.966659 | 354.727542 | 466.833327 | 466.833327 | 21.783333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5.033333 | 16.75 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-30 00:00:00 | 507.499991 | 373.033325 | 362.811157 | 463.249993 | 463.249993 | 28.25 | 3.5 | 0 | 0 | 0 | 0 | 0 | 0 | 1.25 | 0 | 7.5 | 16 | 0 | 0 | 0 | 0 | 0 | 0
2020-01-31 00:00:00 | 464.499992 | 341.999992 | 333.353241 | 414.999993 | 414.999993 | 26 | 3.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.5 | 15 | 0 | 0 | 0 | 0 | 0 | 0