How can I keep Jira Estimates in Hours instead of Jira converting to Days and Weeks

Robert Andrzejewski
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!
March 29, 2012

The reports, when exporting to Excel keep the Days / Weeks. Which make it difficult to do some analysis and costing based on any of the time fields in Jira. I would like to standardize on the hours format.

7 answers

1 accepted

8 votes
Answer accepted
Bryan Choate
Contributor
March 29, 2012

In the Admin console, go to System -> Issue Features, and then select "Time Tracking" on the left. The full documentation can be found here: http://confluence.atlassian.com/display/JIRA/Configuring+Time+Tracking

Robert Andrzejewski
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!
March 29, 2012

Perfect, thank you!

Michael O'Callaghan
Contributor
March 12, 2015

Spot on. Thanks.

Al
Contributor
July 22, 2018

New path

Jira settings > Issues > Time Tracking
Like # people like this
Josh Sommers
Contributor
October 24, 2018

This does not work. The time is still displayed in a variety of formats.

Examples of time display with this setting set:

  • 41.25h
  • 3h 40m
  • 38m

This is terribly inconsistent. Who would want a different format type on every line of a report? Does Atlassian intentionally make this stuff useless so that we're forced to purchase time tracking plugins?

Like # people like this
Josh Sommers
Contributor
February 12, 2019

Yeah, it's absolutely terrible. Atlassian really does not care about their customers or users or about making their software viable in a business environment. Their only answer is for us to buy another plugin that might do it better than JIRA does.

Like # people like this
Srecko Anzic
Contributor
February 28, 2019

I'm having the same problem. I have "Time display format" set to "Hours", and yet Jira Cloud displays tracked time in a mix of minutes, hours, and days.

This is a bug.!

It is affecting TIME ESTIMATE and TIME TRACKING fields!

Like # people like this
Jon Karnofsky
Contributor
March 13, 2019

I'm seeing the same issue.

Srecko Anzic
Contributor
March 20, 2019

It is a bug, please vote\report here https://jira.atlassian.com/browse/JRACLOUD-69369

Like # people like this
Kelly Nezwek April 9, 2019

That bug link seems to be for a different time tracking issue, one regarding the desire to just hit "enter" without needing to input an "h" for hour (etc.).

 

Is there a bug for the issue of time coming through as hours in some places, and as h/d/m in other places, when "Hours" is selected as the default display format that anyone knows of?

Like Andrew Cave likes this
Nina - Phan Thanh Noi
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!
November 20, 2019

I want to export time spent in BigGantt and the number of day/ week made me exhausted to manually convert them into hours or minutes. This is a UGLY bug of JIRA

Don Hamp
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!
September 22, 2020

Does anyone have a solution from the Excel side.   I have a Confluence Pivot of JIRA data which is fixed in the y,w,d,m format that was shared here.    I copy and paste this data to Excel and am looking for an excel formula  that would convert 1y, 2w, 1d, 10m to  the correct # of work days.

7 votes
Mike Walters
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!
September 19, 2019

If anyone is still struggling with this in Jira Cloud, try setting your HOURS PER DAY == 999 and DAYS PER WEEK == 999. This worked for us:

 

Capture.jpg

scott.fawcett
Contributor
September 30, 2019

You don't need to change the Working Hours per day or Working days per week.  Just change the Time display format.  At least that worked for me...but the only place I'm interested in seeing hours only is on the Active Sprint board, so now I see all Remaining Estimates on the cards as hours only...which is exactly what I was hoping to see.

Like # people like this
Tom
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!
January 19, 2020

This works for me too. I changed it to 9999 on hours per week and working days per week and now time is displayed in hours instead of days... Thx Mike Walters

Like Peter Riise likes this
Kevin Benson February 6, 2020

Mike,

You rock.

Kevin

Kelli Frattini-Adams
Contributor
April 1, 2020

Thanks Scott.fawcett,, Exactly what I was looking for!

Laura Jakimonyte
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!
June 12, 2020

ahhhh, finally a solution to this irritating problem. Worked perfectly for me. Thank you!

Rhuan Barreto
Contributor
September 1, 2020

Perfect!!! Definitely the solution!!!

Smeet J Thakkar
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!
February 4, 2021

Thanks, this worked like a charm.

Scott March 22, 2021

This is not a solution as it renders tempo completely useless for timesheet management

Mike Walters
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!
March 23, 2021

While the solution i offered above (https://community.atlassian.com/t5/Jira-questions/Re-How-can-I-keep-Jira-Estimates-in-Hours-instead-of-Jir/qaq-p/1183352/comment-id/376424#M376424) has worked for us and others ...

@Scott is correct, If you use Tempo it will do wonky things like this -- 

screencap.jpg

We use Prime Timesheet instead and it doesn't seem to have any issues - https://marketplace.atlassian.com/apps/294/timesheet-reports-and-gadgets?hosting=cloud&tab=overview

Shame on Atlassian for not just fixing this nearly 3 year old problem - https://jira.atlassian.com/browse/JRACLOUD-69810

Liene
Contributor
April 22, 2021

If You set up Workload and Holidays setup in Tempo setup, then it still gives You right amount of Hours for each person. 

2 votes
fonda
Contributor
September 3, 2019
2 votes
Srecko Anzic
Contributor
March 20, 2019

It is a bug, please vote report here https://jira.atlassian.com/browse/JRACLOUD-69369

1 vote
Deleted user April 10, 2019

I'm having a nightmare trying to set estimates to display as hours. 

I repeatedly have done this:

Administration > Issue Features > Time Tracking > Time Format - Set this to Hours then all will be displayed as hours only

 

It seemed to work... briefly, and I could see estimates in hours. Only, the next time I checked it was back to displaying in days, hours, etc. Then when I went back into the settings, the settings had "changed" themselves back to display in "pretty...", i changed again and went to a project to look at the times and they were still in weeks. The settings seem to change themselves back. Or even if they don't, the times are still displaying in weeks.

 

What gives?

Can anyone help?

Kelly Nezwek April 10, 2019

I can't help, but we are having the same issue!  We're on the cloud version.  It looks like it does change estimates to hours on certain things (the Burndown Chart being one of them), but on actual issues it's still displaying in the "pretty" format.

 

I hope someone is working on a fix for this!

rukshan
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!
July 7, 2019

There is surely a bug in the settings display section. Before you click on the 'Edit Global Settings' button at (...Issue Features > Time Tracking), it displays the 'hours' settings as to how I changed it before.

But when I click to edit it, it displays the default settings (which is "pretty") as the settings there. Which ideally should be the settings which I have set up, but not the default settings.

Other than that, the above setting change seems to be working now. 

0 votes
lrobertson39
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.
March 29, 2012

Administration > Issue Features > Time Tracking > Time Format - Set this to Hours then all will be displayed as hours only

Josh Sommers
Contributor
February 12, 2019

Sometimes it will display as decimal hours, sometimes it will display as hours and minutes within the same search. Totally inconsistent and complete garbage. Can't even use a calculator to add time up manually. And then if you export it to excel, it's all milliseconds.

Srecko Anzic
Contributor
March 20, 2019

It is a bug, please vote report here jira.atlassian.com/browse/JRACLOUD-69369

Like # people like this
sandra whitmore
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!
April 4, 2019

Please fix this. How can we manage the work hours with it this way. Critical management tool for EVM or just knowing how your project tasks are doing.

 

Thanks

Sandra

Nacho Visedo
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!
April 21, 2019

Yesenia pelos Fox this!

 

Its terrible

0 votes
lrobertson39
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.
March 29, 2012

Administration > Issue Features > Time Tracking > Time Format - Set this to Hours then all will be displayed as hours only

Josh Sommers
Contributor
October 24, 2018

Does not work. Still displays values in a variety of formats.

Lukáš Černý January 25, 2019

me for me in tempo

Josh Sommers
Contributor
February 12, 2019

Sometimes it displays as decimal hours and sometimes it displays as hours and minutes, within the same search. So one ticket shows an estimate of 16.25 hours, and another shows an estimate as 8h 35m. In what world is that even REMOTELY helpful? Complete garbage!

Like # people like this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events