How is JIRA calculating Time Spent

Question

I have an Open Issues report I export to Excel to report on certain items. One of them is Time Spent which users log into their issues in the Time Tracking area. The issue is I cannot figure out what the Excel output represents. For example, In Jira someone logged 6w of time. In Excel it shows as 864000. What is this? Seconds? Minutes? If I calculate minutes in 6 weeks it's 60,480 minutes so that's not quite it. I can't use this data until I figure out how to convert this into hours worked.

Bill Sheboy · Answer

Hi @İclal Aslan

First thing, this is a very old thread.  I recommend creating a new question, and perhaps linking back to this one, to ensure the maximum number of people see it to offer suggestions.

Back to your question...

For the time tracking fields which show on issues for Jira Cloud, the time spent does display that way, such as: 2w 3d 4h 2m

What version of Jira are you using, and what are you observing?

Kind regards,
Bill

İclal Aslan · Answer

Hi @Bill Sheboy  is there a way to show on view screen in weeks/days etc.

Bill Sheboy · Answer

Hi @Michael Heilig  -- Welcome to the Atlassian Community!

That is working seconds of time.

You may check this with your Jira Admin, and if they haven't changed anything the time tracking settings default to 5 working days/week and 8 working hours/day.

So...

6 weeks x 5 days/week x 8 hours/day x 60 minutes/hour x 60 seconds/hour = 864,000 seconds

Best regards,
Bill