Logged hours report

[Zaloon]

I've seen that anyone can log hours in any issue in Jira through the field Time Tracking. And that it is possible to check individually in the issues to check who logged hours and how much time he/she spent. Using this kind of information:

Is there any kind of report that can show with this fields included a table like this? :

IssueKey| User                         | Logged hours

3            | Peter                        | 5h

3            | Josh                         | 1h

2            | Josh                         | 1h

2            | Josh                         | 1h

And also I'm wondering if it's possible to export that information to excel.

[Jakub Sławiński · Accepted solution]

Hi @Zaloon ,

there is a separate Time Tracking category on the marketplace with a lot of addons that provide exactly what you described:

https://marketplace.atlassian.com/categories/time-tracking

[Mohamed Benziane · Accepted solution]

Hi,

Did you try the "Workload Pie Chart" ? It will show all the time spent by user in project for example.

If you really need something like a table you will need a plugin or create a your own code using the REST API.

[Aron Gombas _Midori_]

As you mentioned that Excel would be a final result from your process, try the Better Excel Exporter app. It allows creating every sort of interactive reports and charts from Jira worklogs.

(Discl. It is a paid and supported Jira app, developed by my team.)

[Mary from Planyway]

Hi @Zaloon,

I’m from the Planyway team, and just wanted to let you know that you can get Excel reports that would include worklog entries and the info on who logged them from Planyway. It’s also easy to log time in Planyway, either by launching the timer or by dragging and dropping issues on the calendar in the time tracking mode. 

Our app is quite small in Jira universe for now, but that makes us very accessible to our users, we’re open to any feedback. Feel free to ask any questions and share your thoughts if you try our time tracking.

Cheers

[Rahul_RVS]

Hi @Zaloon 

If you would be interested in paid add-on, you can try out our app

Agile Tools : Epic Tree, Links Tree, Time in Status & Worklogs

The app provides the following features. You can also group the worklogs report by Labels.

Worklogs & Time tracking Report :- Track time spent by resources with multiple filters / category / grouping features. Export to csv format is also available. Also resources can enter time spent for multiple days from our Timesheet screen.

Along with this there are multiple other features like Time in Status, Links Hierarchy, Epic Hierarchy etc which the app provide.