This is an open issue since quite long time. I wanted to know if there is a way to export JIRA duration fields to CSV in Days, Hours, minutes format as by default it renders in seconds.
I tried editing duration-columnview.vm and no luck. Version of JIRA is 8.14 Any help is highly appreciated!
PS: I tried workaround on https://community.atlassian.com/t5/Jira-questions/Export-Estimates-in-hours-Day/qaq-p/58647 and no luck!
Welcome to the community. Jira stores duration in seconds and exports it in seconds. Most individuals I know just divide by number of seconds to convert to the proper format that they would like. You can also use a plugin like Better Excel Export https://marketplace.atlassian.com/apps/1212652/better-excel-exporter-for-jira?hosting=server&tab=overview to accomplish what you would like. You can use their formulas or functions to do it on the export.
Unfortunately, JIRA either converts it to seconds or minutes. I have a value of 300 that I thought was seconds, but then checked the actual ticket and it shows that its original value is put in hours. Do we have a workaround on this one? greatly appreciate any help.