Exporting Original Estimate Field

[Diatta Harris]

Hello,

My team uses the original estimate and remaining estimate fields but when we export in .csv and save to .xls it converts the minutes, hours, days and weeks into seconds.  How can we configure those fields to export in the viewable factors and not in seconds?

[Jehan Bhathena · Accepted solution]

Hi @Diatta Harris ,

While I don't have an exact answer to your question, I'll provide the workaround that I use for this scenario.

After downloading the CSV/xls file, I select the row that has the Seconds duration and change the Formatting to hh:mm, this way I get a more defined view that I need.

https://excelchamps.com/formulas/seconds-to-hours-minutes/#Convert_Seconds_into_Hours_hhmmss

Hope this helps. :-)

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Diatta Harris

just to add to that: If you're open to solutions from the Atlassian Marketplace, you'll find a number of options there. 

Just as one example, this would work as expected using the app that my team and I are working on, JXL for Jira, where the export would use whatever time format you configured in Jira (but you can also override it in JXL, if you prefer to do so). This is how this looks in action:

This is really just one example; there's a number of export-focused apps available. If a Marketplace app is an option for you, perhaps try a few and see which one works best for you.

Best,

Hannes

[Sunny Ape]

Hello @Diatta Harris 

How can we configure those fields to export in the viewable factors and not in seconds?

In short, you can't.

Google 'Jira export CSV time in seconds' to see where this question has been asked many times before.