Jira - logging hours on sub tasks

[Ofira Daniel]

Hi ,

Case - I have in Sprint 1 user story X , I started to work on it in Sprint 1 and as I didn`t complete it , user story moved to Sprint 2 and there I completed it.

Is there a way to calc how many hours were logged in each sprint on this user story sub tasks ? 

Thanks 

[Aron Gombas _Midori_]

You can export the worklogs to Excel using the Better Excel add-on for JIRA, then create a pivot table where the "sprint" is one of the dimension and sum(worklog) is the key metric.

[Gezim Shehu [Communardo]]

But the sprint field will already be changed ?

Maybe worklog created time checking between sprint start/end date will do ?

[Nic Brough -Adaptavist-]

An issue can be in many sprints.  Aron's suggestion on the pivot will work because of that.

[Gezim Shehu [Communardo]]

Ahh I thought he meant changed the sprint by "move".

(Y)

[Ofira Daniel]

how can I export the worklogs to excel ?

[Gezim Shehu [Communardo]]

Try going into Project->Reports->

Forecast & management

[Aron Gombas _Midori_]

@Ofira Daniel With this add-on you can export worklogs in multiple ways to Excel:

1. Along with other issue fields
2. Into pivot tables