Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Time Tracking (fileds) and Export excel

Fred BEAUFILS
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....

Answer
Watch
Like Be the first to like this
3149 views

1 answer

1 accepted

1 vote
Answer accepted
Nic Brough -Adaptavist-
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
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.

View More Comments
Fred BEAUFILS
Fred BEAUFILS October 19, 2014

Thanks Nic.

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

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira Software
TAGS
AUG Leaders

Atlassian Community Events

    See all events