How do I auto log time taken for an issue to go from one status to the next?

[andreas]

Is there a way to achieve auto time logging using this add-on? I want to automate time logging and tracking such that a “timer” starts when an issue transitions to “In Progress” and stops when it transitions to “Done”. At the end of every month, I can then run time reports for management.

[andreas · Accepted solution]

This is a pretty advanced usage but it can be done with Automation for Jira.

It is possible to do this using 2 rules. The first rule stores the first date on the original transition and then the second rule calculates the time difference and logs the work on the second transition.
Your first rule would like:

• On Issue transition
• If the status = "In Progress"
• Set an entity property on the current issue for key "timestamp_in_progress"

  {{#now}}toMinutes{{/}}

The second rule would like:

• On issue transition
• If the status = "Done"
• Log work using the "Edit action" and this in the advanced section:

  {
    "update": {
      "worklog" : [
        {
          "add": {
            "timeSpent" : "{{#=}}{{#now}}toMinutes{{/}} - {{issue.properties.timestamp_in_progress}}{{/}}m"
          }
        }
      ]
    }
  }

This will add how many minutes elapsed between the 2 transitions.

Here's screenshots of the 2 rules:

[Arbak Martirosyan]

Hi @andreas, 

Thanks for detailed description of the rules. But it seems that time is not logged after first transition occurred, and we're seeing "No time logged" on issue page. 

Are these rules only calculating time after final transition to "Done"? 

[Petr A]

@andreas  Hi Andreas! Thanks for ur answer! It was 3 years ago, but how do u think, is it possible to upgrade this 2 autimation rules to collect only working time (9 AM - 6 PM; 5/7)?:)

[Jack Hunter _HeroCoders_]

It might be easier to use Clockwork for automated time tracking as it does not require writing rules manually. It also logs time as a real user. 

[Petr A]

Jack, thanks! Yes, we are already using clockwork, everything is fine)