Morning All,
Im having more of a mind block I think on doing this today. I'm calculating simple capacity ie we have
I want an output which would show how many tickets we could work on before running out of time
Im using a fairly long if statement, and then adjusted down the priorities - there must be a simpler function !?
Thanks in advance, sorry for being slow on a monday morning!
Im having more of a mind block I think on doing this today. I'm calculating simple capacity ie we have
- 180 hours in a month
- Hours spent on each prority
Critical | 2 |
High | 4 |
Medium | 6 |
- Expected amount per month
Critical | 10 |
High | 30 |
Medium | 40 |
I want an output which would show how many tickets we could work on before running out of time
Critical | 10 (ie 2*10 = 20) |
High | 30 (30*4=120 running total 140) |
Medium | 1 (1*40 = 40) running total 180) |
Im using a fairly long if statement, and then adjusted down the priorities - there must be a simpler function !?
Thanks in advance, sorry for being slow on a monday morning!