I need some hwlp trying to figure out a formula. Here's my problem.
I have a set time in which we start and a set amount of how many we should produce in a day. How do i figure out how many i should have done at any given hour? Say i start at 6:00 and i can produce 20 an hour and i have 50 to produce. At 7:00 i should have 20 done and at 8:00 i should have another 20 done the how do i figure out that at 8:30 i should be done and should start on my next set up.
Windows XP
Excel 2003
I have a set time in which we start and a set amount of how many we should produce in a day. How do i figure out how many i should have done at any given hour? Say i start at 6:00 and i can produce 20 an hour and i have 50 to produce. At 7:00 i should have 20 done and at 8:00 i should have another 20 done the how do i figure out that at 8:30 i should be done and should start on my next set up.
Windows XP
Excel 2003