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

0 vote
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

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira Service Desk

How the Telegram Integration for Jira helps Sergey's team take their support efficiency to the bank

...+ reading Fantasy). The same is true for him at the bank he works for: Efficiency is key when time literally equals money. Read on to learn how Sergey makes most of the time he has by...

351 views 2 4
Read article

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