Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
JonesBeach
Contributor III
Contributor III

Calculate number of days spent in each stage

Hi guys,

I am trying to calculate the number of days being spent in each stage of manufacturing. The difference in two subsequent dates shows the result as the number of days spent in each stage of manufacturing  process. 

In the data set "Product_ID" PP540 has 5 stages so far and "Time_Spent_In_Each_Stage"shows number of days spent in each stage and the last manufacturing stage is Dryer which should be counting the number of days from the beginning of that stage to the whatever is the current date is.  

Thanks for the help in advance! 

Regards!

 

 

Labels (3)
1 Reply
JonesBeach
Contributor III
Contributor III
Author

Could anyone please help with this!! I really need to get this done ASAP   

Regards!