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

[Raquel Costa]

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

[Tolun Ozarslan]

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]

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

[Tarun Sapra]

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)