How to convert time in jira database to days

Martin_ukbd1r

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 P Claspill

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