Export and Hours

Hi,

I'm new to JIRA and couldn't find appropriate place where to put my questions.

  1. Is there any possibility to display spent time in hours and not to combine them into days when they reach hours per day. For example: my working hours is 8 and my partner is 6, we worked on issue 24 hours and JIRA shows 3 days. It's a little bit confused, because my 3 days are not the same with my partner. I also reporting my time to get paid in hours and it's hard to transfer JIRA combined days into hours to provide my reports. Is there any option to prevent JIRA combine hours into days?
  2. When I export list with my tasks and issues to excel file, all columns with time shows time in seconds and not in hours.

001.JPG

002.JPG

 

I have to spend additional time to divide every single such column to 3600 to get proper time in hours. Is there any possibility to get this right?

 

Thank you.

2 answers

1 accepted

This widget could not be displayed.
  1. Go to Admin -> Time Tracking, and turn off "pretty" time formatting
  2. This is already "right".  It's going to stay as seconds because that is the best option

JIRA stores and exports the duration type data in seconds because a few people might need that granularity.  Most need hours or minutes to be frank, but storing it in seconds gives you the flexibility to support everyone who needs seconds upwards.

So, I've just said "most need hours or minutes", but which one would you choose?  You'd want hours.  I've got a lot of users that need minutes, so they'd have to do the conversions that you're doing from seconds, but from hours, so I'd vote for minutes on their behalf.  But I've got others who need hours.  And days.

This widget could not be displayed.

As Nic said the data is stored with second precision, which you can precisely export to an Excel worksheet using the Better Excel Plugin.

It will keep your data separate from its presentation format, and simply allow to use Excel formulas or formatting features (right click and select format) on the data. So, you can turn those seconds to minutes or hours or a combination of those (01:45 for example), whichever you prefer.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

143 views 1 3
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you