This article is for Structure Data Center.
Problem
When I export my structure to Excel, the columns with duration values - Time Spent, Original Estimate, and Remaining Estimate - are displayed in a different format of XX:00 instead of the Jira format of weeks, days, and hours.
Solution
The observed behavior happens for two reasons:
-
Structure doesn’t additionally convert Jira duration values during export, i.e. the values are exported as is.
-
Excel interprets such values in its own way, resulting in the XX:00 format.
As a workaround, you can use the Formula column for converting the value before export: https://help.tempo.io/structure-dc/latest/formulas
With a formula like this: jira_hours(originalestimate) you can convert a column’s value into a number of hours. The jira_days() function can be used for converting the value in days.
If you have multiple duration-type columns, you can add multiple Formula columns, each converting the existing duration column’s values. And when the formulas are configured, you can export the structure and see the values in the file unchanged.