time format

[sergeev.viacheslav@telestarcom.ru]

When uploading data to excel in columns L and O different time format, in L format 24 hours, in O format 12 hours, how to bring the format O to 24 hours, when changing the format in the menu, the cell format does not change.

[sergeev.viacheslav@telestarcom.ru]

Thank you, I figured out the problem, the interface didn't match the Jira.time and jira.script.time formats? after the correction, everything is displayed correctly.

[sergeev.viacheslav@telestarcom.ru]

Query formats such as cell L1 ${outlookdate.formatDMYHMS(issue.getCreated ())}
cell O1 ${fieldHelper.getFieldValue(issue, " customfield_10249")}
Cell format

[John Funk]

Hi Sergeev,

I don't believe you are going to be able to upload two different time formats at the same time with the import feature. 

Why not upload both in the same format and then use some automation to change the value of one of the dates after the fact? Also, are you currently displaying dates in Jira in two different formats?