You are viewing documentation for Structure Server and Data Center version 5.6 and patch releases. For other versions, see Version Index or [Structure Cloud].
When you export a structure to Excel, the time tracking information is shown in hours format, rather than Jira's duration format (e.g., 1w 3d 5h 20m).
To convert this data back to the Jira Duration format, use the Excel Macro and instructions below.
Only Excel 2010+ is supported. It is possible that the macro will work with the 2007 version, but we can't guarantee it.
In the dialog, click the 'Browse' button and select the downloaded FormatTimetrackingData.xlam
The selected cells will be converted to a string in the Jira duration format, such as "1w 3d 5h 20m".