How to calculate total time spent From To Do to Done

Anonymous_h2xitf

We have a requirement that we have some statuses like “To Do → In Progress → Awaiting on Dependency → In Review → Done”.  

 

We have to calculate the time spent from “To Do to Done”. 

Hence we do not have to calculate the time of “Awaiting on Dependency”.

Only we have to calculate the time “To Do → In Progress → In Review → Done”. 

Damian Wodzinski_ayk1y7

Hi,

I resolved similar problem, this will require third party addons. In my case, it was "ScriptRunner for Jira".

It would take some time, to develop the correct solution, but I will share my code with you. In this case, I had to skip time, during which ticket was in pending state, and also I had to skip counting, during weekends.

If you do not need to calculate weekends as I did, you can simply get the time, from creationd date till the resolving date. Then by looping through statuses changes, find how long it took to stay in "Awaiting.." status, then simply substract those two values.

import com.atlassian.jira.issue.Issue
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.changehistory.ChangeHistoryItem
import java.sql.Timestamp
import com.atlassian.jira.issue.changehistory.ChangeHistoryItem.Builder
import com.atlassian.jira.issue.history.ChangeItemBean
import java.util.Calendar
import java.time.*
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;

def issueManager = ComponentAccessor.getIssueManager();
def changeHistoryManager = ComponentAccessor.getChangeHistoryManager();
long resultMillis = 0l;
def result = "";
List<ChangeItemBean> status = changeHistoryManager.getChangeItemsForField(issue, "status")
ChangeItemBean first = new ChangeItemBean("jira", "status", "created", "created", "Waiting for support", "Waiting for support", issue.getCreated())
status.add(0, first)

for(int i = 0; i < status.size(); i++){
def start = status[i].getCreated().toLocalDateTime();
//log.error(status[i].getToString() + " " + i)
//log.error(start)
if(!status[i].getToString().equals("Pending") && !status[i].getToString().equals("Closed") && !status[i].getToString().equals("Resolved")){
if(i != status.size()-1){
def end = status[i+1].getCreated().toLocalDateTime();
if( end.getDayOfWeek().equals( DayOfWeek.SATURDAY )) {
end = end.plusDays(2).toLocalDate().atStartOfDay().plusHours(8).plusMinutes(1);
}
if( end.getDayOfWeek().equals( DayOfWeek.SUNDAY )) {
end = end.plusDays(1).toLocalDate().atStartOfDay().plusHours(8).plusMinutes(1);
}
if( end.getHour() >= 22){
end = end.plusDays(1).toLocalDate().atStartOfDay().plusHours(8).plusMinutes(1);
}
if( end.getHour() < 8) { 
end = end.toLocalDate().atStartOfDay().plusHours(8).plusMinutes(1);
}
if( start.getDayOfWeek().equals( DayOfWeek.SATURDAY )) {
start = start.plusDays(2).toLocalDate().atStartOfDay().plusHours(8);
}
if( start.getDayOfWeek().equals( DayOfWeek.SUNDAY )) {
start = start.plusDays(1).toLocalDate().atStartOfDay().plusHours(8);
}
if( start.getHour() >= 22){
start = start.plusDays(1).toLocalDate().atStartOfDay().plusHours(8);
}
if( start.getHour() < 8) {
start = start.toLocalDate().atStartOfDay().plusHours(8);
}
log.error("Status: " + status[i].getToString() + " Created: " + start + " i: " + i)
log.error("End /(next status start/): " + end)
while(start.isBefore(end.minusDays(1))){
def last = start.toLocalDate().atStartOfDay().plusHours(22);
ZonedDateTime zdtStart = ZonedDateTime.of(start, ZoneId.systemDefault());
ZonedDateTime zdtLast = ZonedDateTime.of(last, ZoneId.systemDefault());
long starte = zdtStart.toInstant().toEpochMilli();
long laste = zdtLast.toInstant().toEpochMilli();
resultMillis = resultMillis + laste - starte
start = start.plusDays(1).toLocalDate().atStartOfDay().plusHours(8);
if( start.getDayOfWeek().equals( DayOfWeek.SATURDAY )) {
start = start.plusDays(2).toLocalDate().atStartOfDay().plusHours(8);
}
if( start.getDayOfWeek().equals( DayOfWeek.SUNDAY )) {
start = start.plusDays(1).toLocalDate().atStartOfDay().plusHours(8);
}
} 
ZonedDateTime zdtStart = ZonedDateTime.of(start, ZoneId.systemDefault());
ZonedDateTime zdtEnd = ZonedDateTime.of(end, ZoneId.systemDefault());
long starte = zdtStart.toInstant().toEpochMilli();
long ende = zdtEnd.toInstant().toEpochMilli();
resultMillis = resultMillis + ende - starte
} else {
// log.error(status[i].getToString())
if(!status[i].getToString().equals("Closed") && !status[i].getToString().equals("Resolved")){ 
if(!status[i].getToString().equals("Pending")){
ZonedDateTime zdtStart = ZonedDateTime.of(start, ZoneId.systemDefault());
long starte = zdtStart.toInstant().toEpochMilli();
resultMillis = resultMillis + System.currentTimeMillis() - starte
}
}
}
} 
}
long seconds = resultMillis.longValue() / 1000;
long minutes = seconds / 60;
long hours = minutes / 60;
long days = hours / 24;
String time = days + "d " + hours % 24 + "h " + minutes % 60 + "m " + seconds % 60 + "s" + result;
log.error(time)
return seconds;