if elseif formula

[kod2th3e]

I am trying to create a formula that will calculate the estimated completion time of a piece of product. Heres the layout of the sheet:


C2 is 6:30AM - (Start Time)
C3 is 9:30AM - (1st Break)
C4 is 12:00PM - (2nd Break)
E2 is 0:36:00 - (Cycle Time of Unit)
E3 is 0:10:00 - (Length of 1st break)
E4 is 0:20:00 - (Length of 2nd break)

from cell B10 going down I would like the formula to calculate the estimated completion time. So, B10 would be the start time (6:30 AM) + the Cycle time (0:36:00) = 7:06:00 AM, B11 would be the previous units estimated completion (7:06:00 AM) + the Cycle time (0:36:00) = 7:42:00 AM, and so on... Now the tricky part is if the completion of a unit lands during the 1st break or 2nd break time the estimated completion time would be pushed out by the duration of the break. For example if a unit was slated to be completed at 9:32, it would end up showing a time of 9:42 and if a unit was slated to be completed at 12:19 it would end up showing a time of 12:39.


Any advice/help would be appreciated, thanks for looking.

 

[kod2th3e]

I believe that did the trick. Thank you very much for the help.

-Cody