Days of movements for same product

[ILIAS RAFTIS]

Hi all, I want to find the days that a product is kept in a location. The problem i have is that a product can be imported in the same location multiple times throughout the year.

The dataset that i have is the following: Product, Posting date and status. (duration is the desirable outcome)

Please drop any idea, thanks in advance.

 

 

 

product

posting date

Status

Location

Duration

 

 

x

6/7/2019

enter

Y

 

 

 

x

6/9/2019

exit

Y

2

 

 

x

2/3/2019

enter

Y

 

 

 

x

2/15/2019

exit

Y

12

 

 

x

4/3/2019

enter

Y

 

 

 

x

4/10/2019

exit

Y

7

 

 

x

4/21/2019

enter

Z

 

 

 

x

4/24/2019

exit

Z

3