Calculate time duration

[ssphv]

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

[danilang]

@ssphv 

Glad I could help and stretch my brain at the same time.

Dan