How to retrieve/extract the "Time In Source Status"?

Question

Hello,

I would like to know if it's possible to retrieve the time stored in the transition tab for "Time In Source Status"?

Actually, as you can see in the attached picture, I would like to extract the time for the specific transition "Pending Customer --> In Progress" (then 3d 4h 7m).

http://www.casimages.com/img.php?i=120313101930394827.jpg

To capture some specific transition dates, we implement customized fields with action that filled it during a specific transition and it works fine.

Is it possibe to do the same by capturing this value "Time In Source Status" and copying it in a customized field (we do not success at the moment)? Is there any other possibilities?

Thanks in advance for you help.

Filipe

Angell Tsang · Answer

You could design your workflows to only allow that initial status to exist once, and any loop back would be a completel different status.

Renjith Pillai · Answer

May be before overwriting, take the existing value from the customfield sum it up and store again?

Filipe Do Monte · Answer

Thanks for your answer.
If I understand well, you suggest to calculate a difference between "the time when I enter the status Pending" and "the time when I go back to In Progress". Actually it could work if I do this transition only one time.

But during the lifecycle of the object, we could performed several time this transition, the date will be then systematically overwritten and I will not have the complete time spent on the Pending status (only the last one).
Currently on the transition tab, the time is always added and only one appears even for several transitions "Pending --> In progress". (I hope I'm clear :) ) 
That's why for me, extract this time would have been the best.