Report showing hours logged (time spent) over period of time

Hello, I'm trying to get a simple report of hours logged (time spent) over a 5 day period.  I'm currently using this JQL - project = "project x" AND worklogDate >= "2017/1/9" AND worklogDate <= "2017/1/13"

When I dump the results into csv, the "time spent" column shows cumulative hours spent on the tickets, not just the hours "spent" during that week.  I assume this query is pulling these tickets because time WAS logged during that time period, but I ONLY want to know how many hours were logged during this time and not total time spent on these tickets.  Is there a way to do this?

2 answers

1 vote

Hi Jared,

Worklog sum for specific time periods is not a built-in functionality.

The cheapest addon that lets you get that info is Time Reports:

That's the addon we use in our organisation, it's cheap ($5 or $10 per month), has good and fast support and I definitely recommend it.

Hope it helps.

Thank you!  i will definitely look into this add-on.

Hi Jared,


There is a much more complete solution that is a lot easier to use and also cheaper.

Hope this helps 


Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Featured Groups

Tuesday tips & tricks: What is the Atlassian Community?

It's officially Tuesday, which means it's officially time for another tip to help you better navigate this space we call the Atlassian Community. 😄 I got a great question from community member, Sa...

121 views 6 8
View post

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