Issue with Assigned Date format - Jira to Sheets addon

Gabriel Wong Siong Tung

Hello everyone, have anyone encountered this issue before where by I am trying to export the Assigned Dates of an issue to Google Sheet via the Jira addon, but the hours showing on the Sheet is not correct? 

While the minutes and dates are correct, the hour isn't. Is there like a timezone thing that I have to set?

Thanks a bunch peeps !

 

Christopher Yen

Hi Gabriel, 

I believe there is also a time zone setting in Sheets, is it matching the time zone of your Jira instance?

Sheets Time Zone Settings:
(File > Spreadsheet Settings > Timezone)