Time Spent in Excel Data is not the same from the Sprint Burndow

[Thiago Cunha]

I'm trying to see how much time the team has spent in a previous sprint and also have number which I can rely. When I do the sum in excel it show a diferent number comparing to the sprint burndown. 

I know that the issues retrieved from the excel sums all of the worklogs from all of the sprints. I think that's is what giving me the wrong number. 

So, can you guys help me? what's the calculation in the sum of spent work in the sprint burndown from jira and how can I replicate it to the excel? 

Number from excel sum and number of the sum of the spent time in the sprint burndown report:

[Nic Brough -Adaptavist- · Accepted solution]

There is no way to help you with this, there is no information in the question to work with.

We need to know exactly what you are downloading into Excel (how you're downloading might be needed too) and what you think is in the sprint.

[Thiago Cunha]