JIRA 5.2: How to format milliseconds in hh:mm:ss

[Rumit Patel]

I have a scripted filed using which I want to show the Turn Around Time (TAT) on the Issue Navigator.

So far, following is the formula I am using to get the TAT in miliseconds.

(issue.resolutionDate != null) ? String.format("%d milisecs",(int)((issue.resolutionDate.getTime() - issue.getCreated().getTime()))) : "N/A" ;

Is there any way to convert these milliseconds back to 'hh:mm:ss' format in JIRA?

Regards,

Rumit

[Rumit Patel · Accepted solution]

Found the answer!!!

import java.util.concurrent.TimeUnit;

int TATmili = (int)((issue.resolutionDate.getTime() - issue.getCreated().getTime())) ;

String TATFormated = String.format("%02d:%02d:%02d", 

    TimeUnit.MILLISECONDS.toHours(TATmili),

    TimeUnit.MILLISECONDS.toMinutes(TATmili) - 

    TimeUnit.HOURS.toMinutes(TimeUnit.MILLISECONDS.toHours(TATmili)),

    TimeUnit.MILLISECONDS.toSeconds(TATmili) - 

    TimeUnit.MINUTES.toSeconds(TimeUnit.MILLISECONDS.toMinutes(TATmili)));