How to convert time in jira database to days

[Martin]

Hi there,

I am using Power Bi to make reports from Jira. When I look at a field (Original Estimate), I see a very large number.

We have set Jira to show days in those fields. The values I am getting:

576,000 for 20 days

288,0000 for 10 days

Can you tell me how I can convert 576 000 into days like jira does?

I tried to convert from minutes or seconds, that don't seams to be the case.

Thank you, 

[Trudy Claspill · Accepted solution]

The number of days is being calculated based on the number of seconds in a work-day where 8 hours of work can be done:

60 secs/min * 60 min/hour * 8 hours/day * 20 days = 576,000

[Martin]

Awesome. Thanks for your reply!!!