cancel
Showing results for
Did you mean:
See all
See all
##### Groups
Explore all groups

# 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

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)

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.

Community showcase
Published Jan 08, 2019 in Jira

### How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,111 views 4 9

### Atlassian User Groups

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

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.