worklog per month time tracking

[Laura Fallon]

I am trying to pull a report where it shows all the time that was logged for a specific month. without having to be tied to an epic, or a sprint, or anything. 

Basically, Tom logged 4 hours to a work item in December and then logged 7 more hours in January. I want to be able to pull a report for January and see the 7 hours that Tom logged to that work item. I want a report that shows all the issues with the time for the month spent that I can then on my own in excel add up.

[Robert DaSilva]

Hey @Laura Fallon , you should be able to accomplish this via Jira Filters and a custom JQL query.

Based on your note, you're looking for an excel export that shows all time entries by a specific person, in a specific period of time. Jira offers two fields you can filter against: worklogdate, and worklogauthor.

Here's how I would recommend building your query:

worklogdate > 2025-12-01 AND worklogdate < 2026-02-01 AND worklogauthor = Tom

The worklog author is going to require an Atlassian Account, so you'll need to type that in manually and select the right person from the pop-up that shows.

This will give you a list of Jira work items where Tom has logged time, between the dates of Dec 1st and Feb 1st. When you export this data to Excel, make sure you select the "All Fields" option so that all the relevant work log entries export. You can then do some excel magic to convert the time in seconds into minutes or hours.

Hope this helps!

Robert

[Trudy Claspill]

Hello @Laura Fallon 

Adding to this..

In your first sentence you asked for a report of all time logged during a specific month.

Jira does not natively provide a report of the time logged in a given time period 

As described by @Robert DaSilva  you can get a report of all the issues against which time was logged in a given time period. And you can export all data for those issues to get all the time logged against those issues regardless of when that time was logged. You would need to use another tool to reduce that to only the work logs that fall within your specified time period.

There are third party apps that would enable you to get the report you asked for. Are you open to using a third party app?

[Rahul_RVS]

Hi @Laura Fallon 

Welcome to the community !! 

As suggested by everyone, a mktplace app can help here. If you are open to try out one for detailed time tracking reports, pls take a look at 

Worklogs Time Tracking in Jira & Timesheets

With this add-on, you can easily -

• Create time reports in real time by grouping & categorizing data with aggregation
• Prepare your reports based on Project/Sprint/Issue Type/Assignees and various other filters
• Group your data to build more meaningful reports
• CSV Export
• Dashboard gadget
• Enter Time Spent for multiple issues from Time sheet screen. With Calendar view and Board view

Disclaimer : I am part of the dev team