CSV export for "Original Estimate" makes no sense

[paul]

For example, an estimate of 2 days 4 hours is exported as "72000". 

72000 in what units? 

It can't be minutes -- a day has 1440 minutes

It can't be seconds -- a day has 86400 seconds

WTF? 

[Ana Livia Rocha Silva]

Hi @paul 

I believe it is seconds, but it's only counting work hours for the 2 days. So:

• 2days x 8hours = 16hours x 60min x 60sec = 57600
• 4hours x 60min x 60sec = 14400
• Total = 72000

Kind regards,

Ana 

[Marek Bujak]

@Ana Livia Rocha Silva you might be right:) API returns below information.

 

   "timetracking": {

      "originalEstimate": "2w 4d 1h 30m",
      "remainingEstimate": "2w 4d 1h 30m",
      "originalEstimateSeconds": 408600,
      "remainingEstimateSeconds": 408600
    }

It's also worth being careful while working with exports like this one in Excel. It likes to convert such values in excelish dates/number formats.

[John Funk]

Hi Paul - Welcome to the Atlassian Community!

1 hour indeed is 3,600 seconds

1 day in Jira land is 8 hours. So 2 days is 16 hours. 

16 + 4 hours = 20 total hours x 3600 = 72,000