Formula To Calculate Dates That Overlap

[MrMaker]

Morning all,

Another little piece of help required please, this time regarding dates/times that overlap.

Example Data:

I need to calculate the number of days overlapping within the data for each unique Name.

[TABLE="width: 449"]
<tbody>[TR]
[TD]Name (A)
[/TD]
[TD]Start (B)
[/TD]
[TD]End (C)
[/TD]
[/TR]
[TR]
[TD]Dave
[/TD]
[TD]08/02/2018 09:00
[/TD]
[TD]08/02/2018 11:00
[/TD]
[/TR]
[TR]
[TD]Dave
[/TD]
[TD]08/02/2018 09:00
[/TD]
[TD]08/02/2018 12:00
[/TD]
[/TR]
[TR]
[TD]Tom
[/TD]
[TD]08/02/2018 09:30
[/TD]
[TD]08/02/2018 15:30
[/TD]
[/TR]
</tbody>[/TABLE]

So in the above example the expected outcome for Dave's total overlap would equal 0.0833 (or in other words 2 hours).

Thanks in advance

MM

 

[Special-K99]

I have this formula for overlapped time but this is just for the same day

Overlapped time (same day)
A1 B1 Start Finish Range 1
D1 E1 Start Finish Range 2
=MAX(0,MIN(B1,E1)-MAX(A1,D1)+1)

 

[MrMaker]

Ah thanks SK, sadly my date ranges will be all over the place........the search continues

 

[MrMaker]

If there are any other potential solutions or workarounds I’m all ears………….

Thanks very much