Time spent

[mallikarjun kalal]

Is it possible to calculate time as below equation in jira ?

Time = (Date that status was set to ‘In Progress’ - Date that status was set to ‘Open’ or Date Created)

I tried in script runner plugin with scripted field

import com.atlassian.core.util.DateUtils
DateUtils.getDurationString(((issue.getStatus("In Progress").getTime() - issue.getCreated().time) / 1000) as Long)
but i didn't find method to calculate time for particular status of an issue.

please help me
Thanks,
Arjun

[Mark McCormack (Adaptavist)]

There is a ScriptRunner document that covers how you might go about doing this as a Script Field.

[Nic Brough -Adaptavist-]

Correct, there isn't a function you can use.  You can do it, of course, but what you'll need to to is read the history of the issue for when the status was entered and left and extract the time between those two date/times (possibly many times if an issue looped back through the workflow)

[mallikarjun kalal]

any solution ?