Hi,

I am trying create a report which provides information about how much time a document stayed in a particular folder. For example, a document might be in folder A and then be moved to B and then to C. The document might rotate between these folders again till it reaches an end state folder say D.

The report  says A - 10 hours ( sumof multiple routing ) B - 15 hours. 

What is the best way to capture data using workflow to achieve this ? 

I am currently building workflow to capture date time for document creation, each movement and planning to arrive at datediff grouped by document id. 

Please suggest any alternative solution if you had a similar requirement