How are working hours used in control chart and the effect of "include non working days"

Hi,

In our global time tracking settings we have 

Working hours per day - 8

Working days per week - 5

In the control chart for a sprint board I see the following values:

- Without including non-working days in calculations the shown average is: 
1w 3d 14h average

- If I choose to "include non-working days" the average will be: 
2w 4h 54m average


Since we consider 8 hours per day and 5 days per week I imagine that

1w 3d 14h = 5*8h + 3*8h + 14h = 78h

When adding non-working days I would expect that an extra 16h (2x8h) would be added. So converting the above number would result in 18h+16h = 94h

What I get:

2w 4h 54m = 7*8h + 4h + 54m = 60h54m

 

If instead of using 8h days in calculations we use 24h days it doesn't match also.

I couldn't find any information regarding how these calculations are done. 

All help is appreciated!

 

Thanks

 

 

 

 

2 answers

This widget could not be displayed.
Tarun Sapra Community Champion Nov 15, 2017

I think the data is correct, because the value for non-working days is

*1w 3d 14h average*

And the value for "non-working days included is" 2w 4h 54m average

Thus, I don't see any discrepancy in this as for 2 week sprints the total number of non-working days is "4" (2 weekends) thus if you add 4 days to the initial value of *1W 3d x hours* then if you add 4 days then it's total is  *2 weeks x hours* which is the final value.

1 w 3d 14 h
+     4d
*2w x hours x mins* (as 3d + 4d = 7d which means 1 Week thus total becomes 2 Weeks) 

This widget could not be displayed.

Hi

Great question.

In your example, if a day is 8 hours, why would it display "14h" ?

It would have said 1w 4d 6h

"Since we consider 8 hours per day and 5 days per week I imagine that

1w 3d 14h = 5*8h + 3*8h + 14h = 78h"

I believe, 1 day = 24 hrs

I'm thinking the same thing, however, it would be great for someone at Atlassian to confirm this.

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...

170 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