How to count days, stop counting, then continue counting from where it left off
I am working on a sheet to track parts that are waiting on different departments, such as Engineering, Debug, Materials etc.
I want to have a drop down box or separate tick boxes if a drop down wouldn't work that would start counting days the part has been on that department.
For example, Part 1 is selected as Materials, and it starts counting number of days. Then when it changes department say to Engineering then it stops counting Material days and starts counting Engineering days. The part could then go back to Materials and the number of days need to continue counting from where it got to the first time. So if it gets to 5 days then changes to Engineering then it would stop counting at 5 for Materials. Then if it goes back to Materials for 4 more days then the count would get to 9.
What would be the best way to make this work?
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!