Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

When you export a structure to Excel, the time tracking information is shown in hours format instead of your Jira , rather than Jira's 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 formatTo convert this data back to the Jira Duration format, use the Excel Macro and instructions below.

Note

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

How to Install

  1. Download the attached Macro: FormatTimetrackingData.xlam

...

  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, The selected cells will have General format and will contain be converted to a string in the Jira duration format like , such as "1w 3d 5h 20m".