Please help on formula to add pauses to order time

[Kamolga]

Hi,

I have an issue with adding pauses to a production machine schedule.
I would need to say when will order 1 and order 2 finish.
Here is an example for Monday:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD][/TD]
[TD]Machine
[/TD]
[TD]Start
[/TD]
[TD]06:00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Shift A
[/TD]
[TD]Pauze 1A
[/TD]
[TD]Start
[/TD]
[TD]09:00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Stop
[/TD]
[TD]09:15
[/TD]
[TD]00:15
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD]Lunch A
[/TD]
[TD]Start
[/TD]
[TD]12:00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Stop
[/TD]
[TD]12:30
[/TD]
[TD]00:30
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD][/TD]
[TD]Pauze 2A
[/TD]
[TD]Start
[/TD]
[TD]14:45
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Stop
[/TD]
[TD]15:00
[/TD]
[TD]00:15
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]Shift B
[/TD]
[TD]Pauze 1B
[/TD]
[TD]Start
[/TD]
[TD]17:00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Stop
[/TD]
[TD]17:15
[/TD]
[TD]00:15
[/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD][/TD]
[TD]Lunch B
[/TD]
[TD]Start
[/TD]
[TD]19:00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD][/TD]
[TD][/TD]
[TD]STOP
[/TD]
[TD]19:30
[/TD]
[TD]00:30
[/TD]
[/TR]
[TR]
[TD]12
[/TD]
[TD][/TD]
[TD]Pauze 2B
[/TD]
[TD]Start
[/TD]
[TD]20:45
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Stop
[/TD]
[TD]21:00
[/TD]
[TD]00:15
[/TD]
[/TR]
[TR]
[TD]14
[/TD]
[TD][/TD]
[TD]Machine
[/TD]
[TD]Stop
[/TD]
[TD]23:00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16
[/TD]
[TD]Orders
[/TD]
[TD]Time to produce
[/TD]
[TD]Start
[/TD]
[TD]Stop
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17
[/TD]
[TD]Order 1
[/TD]
[TD]08:00
[/TD]
[TD]=D1
[/TD]
[TD]=C17+B17+????
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18
[/TD]
[TD]Order 2
[/TD]
[TD]09:00
[/TD]
[TD]=D17
[/TD]
[TD]=C18+B18+????
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thank you in advance for your help!

 

[mole999]

something like TIME(0,0,30) for 30 seconds, would need playing with

 

[Kamolga]

Yeeah that part is easy (adding hours to hours, minutes to minutes), the part I fail is the if-and-or:
Adding the 15 minutes if it end after first pause is easy, but let's say it was supposed to finish 10 minutes before lunch, due to pause, it should finish 5 minutes after lunch.

This simple matter blocks me