**Question description:**

*This user has given permission to use the problem statement for this
blog.*

so im trying to find time out, and i realized it only works if i dont change the current number made, and keep it at 0. other than that, it works well. but i need to including current amount of chairs, so as the day goes along, it gives more accurate time out

Solved by G. Y. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
27/07/2018 - 06:41

Hello

Excelchat Expert
27/07/2018 - 06:41

How are you?

User
27/07/2018 - 06:43

im well

Excelchat Expert
27/07/2018 - 06:43

Nice to hear that

User
27/07/2018 - 06:44

so here, you see ive set up an example

Excelchat Expert
27/07/2018 - 06:44

Ok.

User
27/07/2018 - 06:44

im trying to get it, as i change the current chair, the time out doesnt change

User
27/07/2018 - 06:45

as i increase the chairs done, it decreases the time out which is what i dont want

Excelchat Expert
27/07/2018 - 06:46

Total number of chairs are fixed?

Excelchat Expert
27/07/2018 - 06:46

i.e. 1000

User
27/07/2018 - 06:46

built

User
27/07/2018 - 06:46

the schedule is how many we need to build, and current chair would be how many completed

User
27/07/2018 - 06:46

and chairs left is how many we still need to build

Excelchat Expert
27/07/2018 - 06:47

so for example you have built 50 chairs

Excelchat Expert
27/07/2018 - 06:48

Yes so the chairs left to be built are 950

Excelchat Expert
27/07/2018 - 06:48

so the time required to built would reduce for 950

Excelchat Expert
27/07/2018 - 06:49

Ok. I understand what you are looking for. You need to keep the clock for 1000 chairs but you want to keep increasing current chairs

User
27/07/2018 - 06:49

yes

User
27/07/2018 - 06:50

so if we run at 100% (usually do) the time to get out is 11:16 AM in this scenario.

Excelchat Expert
27/07/2018 - 06:51

=E3*B1/60

Excelchat Expert
27/07/2018 - 06:51

instead of this make it on B2

Excelchat Expert
27/07/2018 - 06:51

B2*B1/60

Excelchat Expert
27/07/2018 - 06:53

So E2 and F2 remains same

User
27/07/2018 - 06:53

alright :) so if we did end up running at say....98%, would i just add a % to it to calculate the remaining time?

Excelchat Expert
27/07/2018 - 06:54

where are you accounting for running 100% or 50%?

User
27/07/2018 - 06:54

100%, but sometimes we run at 98% if we have bad parts

User
27/07/2018 - 06:55

so like....if we ran at 98% that day, all day. instead of 100%

Excelchat Expert
27/07/2018 - 06:55

so if you run at 100% time to complete is 19 minutes

Excelchat Expert
27/07/2018 - 06:55

right

Excelchat Expert
27/07/2018 - 06:56

and if you will run at 98% it will take 19.93 minutes, right?

Excelchat Expert
27/07/2018 - 06:57

I would suggest to add another variable of efficiency

User
27/07/2018 - 06:59

alright. thank you :)

Excelchat Expert
27/07/2018 - 06:59

Since I made it fix to 19

Excelchat Expert
27/07/2018 - 07:00

so when efficiency is 100% it is 19 minutes

Excelchat Expert
27/07/2018 - 07:00

try it now by changing the efficieny

User
27/07/2018 - 07:01

that works :) thank you

Excelchat Expert
27/07/2018 - 07:01

My pleasure.

Excelchat Expert
27/07/2018 - 07:01

Please do provide good review.

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*