Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Time Tracking (fileds) and Export excel

Fred BEAUFILS October 15, 2014

What is the trick/parameter to extract in Excel the fields Time Tracking as they are displayed in issue in Jira.

In issue I have Estimated = 3d and Remaining = 1d

In Export Excel Original Estimate = 86400 and Time Spent = 28800.

It is not nice....

1 answer

1 accepted

1 vote
Answer accepted
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 15, 2014

The "trick" is to add a formula to your spreadsheet - divide it by 3600 to get it in hours.  JIRA doesn't try to format the number of seconds logged in a spreadsheet export.

Fred BEAUFILS October 19, 2014

Thanks Nic.

For me, JIRA has to do export as it dosplays the time ^^

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events