Import CSV - original estimate not correct

[de moor dirk]

Hey,

I am trying to create issues from CSV with original estimate time included. (See picture 1 below)

We are using 37h/Week which is 7.4Hrs/Day. 

Column Original Estimate in Sec is mapped to Original Estimate (See picture 2).

Result is not ok (See Picture 3).

For Subtask 1 : result = 1d 3h 36 min (=39600 sec) which should be 1d 3h 42 min 

For Subtask 2 : result = 2w (=266400 sec) which is ok

For Subtask 3 : result = 7h (=25200 sec) which should be 1d,

I think the cause is the loss of decimals

• 39960/3600 = 11,1 --> 11/7.4 = 1d 3h 36 min (=39600 sec)
• 266400/3600 = 74 --> 74/7.4 = 2w  (=266400 sec)
• 26640/3600 = 7,4 --> 7/7.4 = 7h (=25200 sec),

Can anyone help ?

Pic 1 

Pic 2 

Pic 3