Script to calculate total time between states.

[pratik_kumar]

Hi All,

I want a script which should calculate, he elapsed time of a task   i.e. the time spent between the state "To be started" and the state "Completed" and i don't want to add state"pending " time.

These are the "sc_task" state.

[SN Emy]

Hey,

I need to do the same thing on the Idea and Demand tables.

We use some stats from the task table + new custom stats

The new stats are not taken into consideration.

Do you have an idea? 

[Mahendra RC]

Hello @SN Emy 

I would suggest you to raise another question describing you requirement properly. Because it is difficult to understand your requirement with the below statements

We use some stats from the task table + new custom stats

The new stats are not taken into consideration.

If you provide your requirement clearly what needs to be considered in your calculation it will be easy to provide suggestions