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

Raquel Costa November 15, 2017

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

0 votes
Tolun Ozarslan January 3, 2018

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

Colin Moore September 13, 2018

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

0 votes
Tarun Sapra
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 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) 

Suggest an answer

Log in or Sign up to answer