Automatically log time spent on issue


I need to solve this case:

I need to automatically calculate how many hours user spent to work with issue.

Wherein I need to:

  • Calculate time spent for all issue historical assignees
  • Calculate time spent for each issue status
  • exclude non-working horus and days (we work mon-fri from 09:00 to 18:00)
  • include extra working hours


  • JIRA onDemand
  • Jira Agile: Kanban
  • Jira misc workflow extensions
  • eazyBi reports
  • Workflow have 4 main steps: Analysis - Development - Testing - Documenting
  • We changing assignee: at first - analyst, then - developer, then - QA, etc.

So, I need to count time spent for each transition status for each transition assignee.

Now I try to solve my problem by this way:

EazyBI could count days in transition and transition assignee, so I could make report like this:

In this case day = 8h.

We could plus manually logged time spent for each issue.

But I don't know how to account for non-working days.

I think, that is the better way is using standard jira feature - time tracker and automatically logging time by Post Functions (workflow toolbox plugin).

But Workflow toolbox plugin not avaliable for onDemand Jira (thanks Fidel Castro Armario)

Do you have any?

Thank you.

3 answers


JIRA Workflow Toolbox is currently not available for JIRA onDemand (Cloud). You must be using JIRA Server if you are working with it. Can you confirm that?


Fidel Castro Armario

Thank you for your correction.

I checked, I have only Jira Misc Workflow Extensions.

Corrected text of the question.

In current version cloud (onDemand) eazyBI can't count hours in a way you need. There is workaround for this in JIRA server case. There are plans for future to do some custom calculations during data import to solve this type of problems.

Hi, Alexander Pennie.

With this add-on "Time in Status for Jira Cloud" you can generate some of the reports you need. This add-on can help you:

- to calculate the time spent on each issue status and еxport your data to XLS or CSV (analyze it using your favorite tools, e.g. Excel or Google Spreadsheets)

- to exclude non-working hours and days - to include extra working hours

- to monitor how much time your team member is spending on a request (using the Jira's filter options to select a particular user).

If you want more information, let me know.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 13, 2019 in Marketplace Apps

Marketplace Spotlight: Marketing apps for Confluence to keep your teams working on the same page


254 views 0 6
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you