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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.