AnsweredAssumed Answered

Caculate time spent on each "Status"

Question asked by rortiz312000 on May 17, 2016
Latest reply on Oct 18, 2016 by rortiz312000



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!