I have a table as below with different start and end dates but few have same name. I would like to calculate the total duration for each name. For the name A there is overlapping duration among 4 rows and for B they are discontinuous. I would like to add new field and show total duration for each name. How can I calculate for any type of durations like continuous, overlapping and discontinuous.
Name | Start Date | End Date |
A | 1996-2-26 | 2002-05-30 |
A | 2001-10-27 | 2005-12-29 |
A | 1992-12-14 | 2010-03-01 |
A | 1997-3-3 | 2018-11-28 |
D | 2006-6-26 | 2009-6-19 |
B | 1985-3-22 | 1988-5-29 |
B | 1999-9-3 | 2001-11-2 |
B | 2001-11-7 | 2003-12-31 |
B | 2003-12-31 | 2006-12-11 |
B | 2009-11-24 | 2012-7-10 |
B | 2012-6-27 | 2014-7-8 |
B | 2016-6-28 | 2018-10-3 |
B | 2001-9-29 | 2014-11-15 |
C | 2012-7-31 | 2015-12-15 |
