Uploaded image for project: 'Atlassian Product Integrations'
  1. Atlassian Product Integrations
  2. API-394

Jira Spreadsheets export producing incorrect dates/times

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Low Low
    • None
    • None
    • Jira Cloud for Excel
    • None
    • Severity 3 - Minor

      Issue Summary

      Jira Spreadsheets export producing incorrect dates/times

      Steps to Reproduce

      1. Perform a JQL search
      2. Click on the Open in Microsoft Excel icon.
      3. When presented with the Select your Excel product popup, click Excel on Desktop. This will download the file to your desktop.
      4. Open the file with Microsoft Excel or MacOS Numbers

      Expected Results

      • The dates/time should be displayed as that on your Jira Cloud settings

      Actual Results

      • The dates/times are shown in UTC format

      Workaround

      • Determine your timezone, say UTC+11
      • In Excel, let's say cell A2 has the time in UTC. Add a new cell with the formula: 
        =A2 + TIME(11,0,0)

        where the 11 is the positive offset from UTC.

        1. 2021-03-08_15-49-39.png
          2021-03-08_15-49-39.png
          261 kB

            [API-394] Jira Spreadsheets export producing incorrect dates/times

            Tom Nielsen added a comment -

            In a danish excel - use 

            =K3+TID(2;0;0)

            Tom Nielsen added a comment - In a danish excel - use  =K3+TID(2;0;0)

              Unassigned Unassigned
              kpillai KP
              Affected customers:
              5 This affects my team
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: