Jira cloud for Excel changes Created and Updated fields to UTC format

Question

I use Jira Cloud for Excel, where I execute the following JQL:

project = A AND issuetype = Bug and createdDate >= startOfMonth(0) and createdDate <= endOfMonth(0)

I see that filter shows list of bugs correctly but values for created/updated fields are shown in UTC format in Excel.

Example: Jira shows that the bug was created on 8/1/2024 9:00 AM (AEST). However, Jira Cloud pastes this information into Excel with the creation date in UTC format, which shows as 7/31/2024 11:00 PM.

Boris Zozoulia_iar1sj · Answer

perhaps you would also need to format cell (right click ->Format cells and set a custom format to the source cell, for eg: d/m/yyyy h:mm

Boris Zozoulia_iar1sj · Answer

Alternatively - (this is an Excel answer) - create a new column next to your datetime column and use Excel's formulas: =A1+TIME(10,0,0)

Adolfo Casari · Answer

@Eugenia Rubleva

I guess the paste includes the timezone (AEST) and you are probably in a TZ with 10 hours of difference.

You should update your timezone in your Profile in Jira.