calculate time spent on ticket in jira

Question

Hi All,

I'm not sure how to put this question however i have requirment from a user and they want to add a new coloum in issue navigator. That new colom is going to use a formula to calculate the time spent on that ticket

Age of ticket= current date()- ACKNOWLEDGED_DATE()

where Age of ticket= new coloum that needs to be added in issue navigator

Current date= System curent date and time

Acknowledge date= cutsom field setup in the project.

e.g

Age of ticket= 05/Mar/2014- 03/Mar/2014

ans is going to  be 2 and so Age of ticket should hold the value as 2 and it would be great to have time stamp added also

Neeta Dubey · Answer

i used a custom calculate number filed and wrote a formula which calcuates difference among two dates in hours. later i divide the result by 24 to get number of days.

Tsol · Answer

I think the best approach would be to use groovy scripted fields. Please have a look in the provided link i think you will find what you want.

Cheers

Neeta Dubey · Answer

can any one help on this issue? This is  a critical requirement.