How is JIRA calculating Time Spent

Michael Heilig
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 13, 2021

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. 

1 answer

1 vote
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 13, 2021

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

İclal Aslan
Contributor
October 8, 2024

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

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 8, 2024

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

Suggest an answer

Log in or Sign up to answer