I have a custom SharePoint 2013 list with a Status field, and have a request to capture and calculate the time spent in each status. For example:
Status 1 = 4 days
Status 2 = 1 day
Status 3 = 2 days
I had this idea to create a date field to capture the time in and time out for each status, but I'm stuck and need help/direction in figuring it out. The main issue I'm struggling with, is if it goes from Status 1 to Satus 3 then goes back to Status 2, so it can basically jump around to any status and back again!
I don't really have a clue as to how to make that work, but is it possible with Nintex WF? Any examples you can share would be appreciated!