Time Log displays in Seconds while exporting

Senthil June 14, 2022

We used to log hours for our issue types (Epic, Story, and Sub-task) by our team members and were able to see logged the hours in the JIRA report/view section, but it displays/converted to seconds when we try to export to excel, is there any suggestion/guidelines to update any setting to display the hours while exporting the issues

1 answer

0 votes
Mohamed Benziane
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 14, 2022

Hi,

You can change setting Jira will always export in second, you could juste make a formula in your excel to change the second to Day/Hours...

Or find a suitable plugin in the marketplace like this one :

https://marketplace.atlassian.com/apps/1212652/better-excel-exporter-for-jira?hosting=server&tab=overview

Senthil June 14, 2022

Thank you so much for your quick reply on this. 

Suggest an answer

Log in or Sign up to answer