Spreadsheet: 795274d1662591500-how-to-sum-multiple-datedifs-sum-datedif-hd
Sheet: Sheet1

 |  |  |  |  | 2016-12-08 00:00:00 | 2018-10-15 00:00:00 |  |  | Total
 |  |  |  |  | 2022-09-15 00:00:00 | 2024-07-20 00:00:00
 |  |  |  |  | 2015-04-26 00:00:00 | 2022-02-25 00:00:00
 |  |  |  |  | 2020-01-09 00:00:00 | 2020-09-19 00:00:00
 |  |  |  |  | 2017-01-29 00:00:00 | 2024-06-18 00:00:00
 |  |  |  |  | 2009-10-22 00:00:00 | 2014-12-07 00:00:00
 |  |  |  |  | 2021-06-28 00:00:00 | 2024-11-22 00:00:00
 |  |  |  |  | 2015-07-06 00:00:00 | 2018-02-08 00:00:00
 |  |  |  |  | 2018-09-27 00:00:00 | 2023-11-24 00:00:00
 |  |  |  |  | 2021-12-28 00:00:00 | 2023-03-02 00:00:00
 |  |  |  |  | 2010-12-23 00:00:00 | 2012-07-14 00:00:00
 |  |  |  |  | 2011-04-10 00:00:00 | 2012-09-12 00:00:00
 |  |  |  |  | 2010-07-02 00:00:00 | 2011-09-16 00:00:00
 |  |  |  |  | 2015-02-28 00:00:00 | 2021-08-27 00:00:00
 |  |  |  |  | 2018-12-31 00:00:00 | 2022-03-04 00:00:00
 |  |  |  |  | 2020-12-28 00:00:00 | 2026-12-26 00:00:00
 |  |  |  |  | 2017-06-30 00:00:00 | 2022-02-27 00:00:00
 |  |  |  |  | 2016-05-17 00:00:00 | 2022-09-08 00:00:00
 |  |  |  |  | 2011-10-08 00:00:00 | 2015-08-27 00:00:00
 |  |  |  |  | 2018-05-25 00:00:00 | 2026-04-30 00:00:00
 |  |  |  |  | 2018-06-05 00:00:00 | 2022-02-25 00:00:00
 |  |  |  |  | 2018-11-06 00:00:00 | 2019-09-29 00:00:00
 |  |  |  |  | 2010-11-16 00:00:00 | 2016-09-15 00:00:00
 |  |  |  |  | 2014-09-28 00:00:00 | 2021-07-17 00:00:00
 |  |  |  |  | 2016-08-18 00:00:00 | 2020-05-26 00:00:00
 |  |  |  |  | 2015-04-08 00:00:00 | 2018-04-16 00:00:00
 |  |  |  |  | 2016-07-17 00:00:00 | 2021-10-23 00:00:00
 |  |  |  |  | 2016-07-28 00:00:00 | 2016-09-01 00:00:00
 |  |  |  |  | 2022-11-13 00:00:00 | 2030-10-30 00:00:00
 |  |  |  |  | 2022-06-02 00:00:00 | 2027-06-08 00:00:00
 |  |  |  |  | 2010-02-15 00:00:00 | 2013-11-22 00:00:00
 |  |  |  |  | 2022-05-05 00:00:00 | 2030-06-25 00:00:00
 |  |  |  |  | 2017-03-29 00:00:00 | 2022-07-26 00:00:00
 |  |  |  |  | 2012-04-07 00:00:00 | 2020-02-19 00:00:00
 |  |  |  |  | 2012-01-31 00:00:00 | 2015-02-03 00:00:00
 |  |  |  |  | 2015-02-02 00:00:00 | 2018-09-12 00:00:00
 |  |  |  |  | 2021-12-08 00:00:00 | 2022-10-18 00:00:00
 |  |  |  |  | 2016-08-28 00:00:00 | 2023-01-20 00:00:00
 |  |  |  |  | 2013-12-24 00:00:00 | 2021-10-16 00:00:00
 |  |  |  |  | 2011-12-30 00:00:00 | 2016-05-01 00:00:00
 |  |  |  |  | 2017-01-04 00:00:00 | 2022-01-26 00:00:00
 |  |  |  |  | 2012-02-16 00:00:00 | 2018-02-14 00:00:00
 |  |  |  |  | 2017-03-18 00:00:00 | 2017-03-24 00:00:00
 |  |  |  |  | 2018-01-16 00:00:00 | 2023-02-02 00:00:00
 |  |  |  |  | 2023-01-22 00:00:00 | 2023-03-14 00:00:00
 |  |  |  |  | 2018-05-16 00:00:00 | 2020-05-26 00:00:00
 |  |  |  |  | 2017-11-05 00:00:00 | 2018-04-06 00:00:00
 |  |  |  |  | 2011-04-07 00:00:00 | 2016-05-16 00:00:00
 |  |  |  |  | 2023-02-19 00:00:00 | 2027-12-20 00:00:00
 |  |  |  |  | 2015-11-15 00:00:00 | 2016-12-25 00:00:00
 |  |  |  |  | 2011-06-10 00:00:00 | 2018-07-13 00:00:00
 |  |  |  |  | 2010-08-09 00:00:00 | 2015-02-23 00:00:00
 |  |  |  |  | 2020-09-02 00:00:00 | 2023-11-04 00:00:00
 |  |  |  |  | 2013-03-31 00:00:00 | 2015-08-08 00:00:00
 |  |  |  |  | 2020-10-18 00:00:00 | 2026-07-17 00:00:00
 |  |  |  |  | 2010-07-13 00:00:00 | 2012-05-10 00:00:00
 |  |  |  |  | 2014-07-21 00:00:00 | 2017-07-23 00:00:00
 |  |  |  |  | 2016-04-14 00:00:00 | 2020-07-02 00:00:00
 |  |  |  |  | 2016-02-26 00:00:00 | 2019-04-27 00:00:00
 |  |  |  |  | 2016-04-28 00:00:00 | 2017-05-19 00:00:00
 |  |  |  |  | 2009-07-28 00:00:00 | 2014-11-26 00:00:00
 |  |  |  |  | 2016-04-15 00:00:00 | 2023-08-18 00:00:00
 |  |  |  |  | 2017-12-03 00:00:00 | 2025-07-07 00:00:00
 |  |  |  |  | 2013-03-03 00:00:00 | 2018-11-29 00:00:00
 |  |  |  |  | 2018-07-17 00:00:00 | 2020-10-01 00:00:00
 |  |  |  |  | 2010-05-01 00:00:00 | 2018-06-01 00:00:00
 |  |  |  |  | 2013-11-12 00:00:00 | 2017-06-25 00:00:00
 |  |  |  |  | 2010-08-22 00:00:00 | 2015-06-15 00:00:00
 |  |  |  |  | 2011-01-15 00:00:00 | 2016-11-22 00:00:00
 |  |  |  |  | 2017-01-17 00:00:00 | 2018-11-06 00:00:00
 |  |  |  |  | 2018-12-03 00:00:00 | 2024-12-13 00:00:00
 |  |  |  |  | 2009-08-12 00:00:00 | 2010-03-05 00:00:00
 |  |  |  |  | 2022-01-21 00:00:00 | 2026-03-22 00:00:00
 |  |  |  |  | 2013-06-13 00:00:00 | 2015-11-25 00:00:00
 |  |  |  |  | 2019-06-17 00:00:00 | 2023-04-05 00:00:00
 |  |  |  |  | 2016-01-14 00:00:00 | 2019-10-31 00:00:00
 |  |  |  |  | 2017-11-01 00:00:00 | 2022-02-05 00:00:00
 |  |  |  |  | 2009-09-11 00:00:00 | 2016-06-07 00:00:00
 |  |  |  |  | 2020-11-29 00:00:00 | 2026-11-12 00:00:00
 |  |  |  |  | 2021-11-16 00:00:00 | 2028-08-14 00:00:00
 |  |  |  |  | 2017-04-11 00:00:00 | 2024-03-29 00:00:00
 |  |  |  |  | 2011-11-23 00:00:00 | 2019-02-21 00:00:00
 |  |  |  |  | 2014-11-22 00:00:00 | 2021-02-06 00:00:00
 |  |  |  |  | 2010-06-17 00:00:00 | 2011-03-18 00:00:00
 |  |  |  |  | 2017-04-22 00:00:00 | 2020-08-16 00:00:00
 |  |  |  |  | 2012-12-12 00:00:00 | 2017-07-24 00:00:00
 |  |  |  |  | 2022-12-06 00:00:00 | 2029-01-30 00:00:00
 |  |  |  |  | 2015-06-03 00:00:00 | 2018-11-09 00:00:00
 |  |  |  |  | 2011-06-20 00:00:00 | 2015-01-31 00:00:00
 |  |  |  |  | 2010-06-22 00:00:00 | 2016-09-07 00:00:00
 |  |  |  |  | 2019-03-10 00:00:00 | 2020-05-06 00:00:00
 |  |  |  |  | 2021-07-04 00:00:00 | 2025-02-12 00:00:00
 |  |  |  |  | 2018-04-07 00:00:00 | 2020-12-02 00:00:00
 |  |  |  |  | 2021-10-29 00:00:00 | 2024-11-05 00:00:00
 |  |  |  |  | 2012-03-16 00:00:00 | 2016-10-26 00:00:00
 |  |  |  |  | 2019-11-15 00:00:00 | 2027-06-05 00:00:00
 |  |  |  |  | 2011-06-10 00:00:00 | 2018-09-06 00:00:00
 |  |  |  |  | 2017-02-12 00:00:00 | 2025-01-04 00:00:00
 |  |  |  |  | 2016-01-11 00:00:00 | 2018-04-22 00:00:00
 |  |  |  |  | 2017-09-30 00:00:00 | 2020-11-22 00:00:00