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.
<tbody>
</tbody>
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
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.
Name (A) | Start (B) | End (C) |
Dave | 08/02/2018 09:00 | 08/02/2018 11:00 |
Dave | 08/02/2018 09:00 | 08/02/2018 12:00 |
Tom | 08/02/2018 09:30 | 08/02/2018 15:30 |
<tbody>
</tbody>
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