nkiederlen
New Member
- Joined
- Sep 10, 2014
- Messages
- 1
What I'm basically trying to do is create a formula where I can predict when production of a product will be complete but it will be dependent on how many shifts each day will be running the product.
<tbody>
</tbody>
This is what I have right now.
In Anticipated Finish, this is my equation: =IFERROR(IF(O3>0,($K$3+(P3/24)),""),"")
I know its basic but I was just using this as a basic reference. Instead, we are going to start using it to help with scheduling.
I would like to be able to enter in another column if we are going to be running on 1st (7am-3pm), 2nd (3pm-11pm) and/or 3rd (11pm - 7am) as well as exclude weekends. I would like the formula to then return the anticipated finish to reflect the correct date and time.
Example. Start date of 9/10/2014 at 7:00AM. All the same date above. What I return now is above. What I would like it to return is if I am only running on 1st shift, that I would complete the project on 9/19/2014 at 3pm.
Hope that makes sense.
Start Date | Cycle Time | Heats Left | # of Cavities | Run Balance | Hours Left | Anticipated Finish |
9/10/2014 7:00 AM | 10 | 384 | 64 | 24576 | 64 | 9/12/2014 11:00 PM |
<tbody>
</tbody>
This is what I have right now.
In Anticipated Finish, this is my equation: =IFERROR(IF(O3>0,($K$3+(P3/24)),""),"")
I know its basic but I was just using this as a basic reference. Instead, we are going to start using it to help with scheduling.
I would like to be able to enter in another column if we are going to be running on 1st (7am-3pm), 2nd (3pm-11pm) and/or 3rd (11pm - 7am) as well as exclude weekends. I would like the formula to then return the anticipated finish to reflect the correct date and time.
Example. Start date of 9/10/2014 at 7:00AM. All the same date above. What I return now is above. What I would like it to return is if I am only running on 1st shift, that I would complete the project on 9/19/2014 at 3pm.
Hope that makes sense.