Page tree

This documentation relates to an older version 5.2 of the Structure for Jira. Visit the current documentation home.

Skip to end of metadata
Go to start of metadata

When you export a structure to Excel, the time tracking information is shown in hours format instead of your Jira duration format (e.g., 1w 3d 5h 20m). 

Below is the Macro and instructions you can use to convert this data into a string of that format.

Only Excel 2010+ is supported. It is possible that the macro will work with the 2007 version, but we can't guarantee it.

Download the attached Macro: FormatTimetrackingData.xlam

How to install

  1. In Excel open File | Options | Add-Ins.
    1. Select Manage | Excel Add-Ins and click Go
    2. In the dialog, click the 'Browse' button and select the downloaded FormatTimetrackingData.xlam 

    3. Make sure that the checkbox is selected for the 'FormatTimetrackingData' option and click OK.
  2. In Excel go to File | Options | Customize Ribbon.
    1. On the right, select the tab where the button for running the macro will go (e.g., View). Select the desired tab.
    2. Click New Group to add a custom group in the selected tab.
    3. Select the added group and click Rename. Select an icon and a name for it and click OK. A button for using the macro will be created.
    4. Go to Choose commands from | Macros, select FormatTrackingData, click Add and OK.

How to use

  1. Select the data to convert.
  2. Click the created button on the ribbon.

As a result, selected cells will have General format and will contain a string in the Jira duration format like "1w 3d 5h 20m".