Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Question about tickets import and duration format

David CRESPIN
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 20, 2020

Hello


I prepared a CSV file with many tickets to import into my project (JIRA 8). I have a time rounding problem after importing.
I explain: The CSV file is simple with 5 columns: summary, description, label, original time, estimated time.
According to the JIRA manual, the time format should be in seconds.
For example I have 5.52 days for a task. I convert this date into seconds (8 hours per day, 5 days * 28800 seconds, 0.52 days * 8 * 3600). 5.52 days = 158976 seconds.
After import, in this example the duration is rounded to 5.

Why have I lost the decimal values?

Thanks for your help.

 

1 answer

0 votes
valeriia.astakhina
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 9, 2023

I have the same issue. Have you found the answer?

Suggest an answer

Log in or Sign up to answer