Set 'break' after certain time

[navic]

I work on one task with multiple conditions and I solved it around 90%. (I use the Excel 2013)
There is one problem left.
I can not find a way to subtract time while I copy the formula down and set a break after a certain time.

I use this formula below, into 'B' column and everything is fine until the last non-empty row in 'A' column. (The same formula in 'E' column works correctly).

=IFERROR(IF(A3=0,A2,ROUND(A1-A2,9)),0)

In the 'C' column to set 'break' I use this formula below.

=IFERROR(IF(IF(B2>=0,006944444,"break",C1+B2)>=0,"break",IF(B2>0,006944444,"break",C1+B2)),"")

Can someone tell me where I'm wrong?

 

[pecoflyer]

The result in B12 of a11-a12 is 5:28-5:27 which is 0:01 Why should it be 0:11???

 

[navic]

Why should it be 0:11???

The last cell in the 'B' column that contains more than 10 minutes is 'B4' (0:16).
The last cell in the 'C' column which contains a break is 'C4'.

The 'A4' cell contain 5:38
The 'A12' cell contain 5:27

5:38-5:27=0:11

 

[navic]

I want to note, that my formulas do not necessarily have to be used.
Any solution that gives the desired result will satisfy my needs.

 

[bosco_yip]

Just guessing,

Still using your formula in Column B and Column E

Column C and Column F is the "Result" column

And,

In C2, formula copied down, then copied right to F2 and copied down :

=IF(B1="","break",IF(SUM(INDEX(B$1:B2,INDEX(MATCH(1,0/(C$1:C1="break")),0)+1):B2)>=0+"0:10","break",""))

 

[navic]

@bosco_yip
Thank you for the solution offered.

I solved it an hour ago.
My long formula

=IF(OR(IF(B1="","break",IFERROR(IF(ROUND(IF(INDEX(B$2:B2,MATCH(MAX(B$2:B2),B$2:B2,0),1)>=0,006944444,INDEX(A$2:A$112,MATCH(INDEX(B1:B$2,MATCH(MAX(B1:B$2),B1:B$2,0),1),B$2:B$112,0),1)-A2,0),9)>0,006944444,"break",""),""))="break",B2=0,006944444),"break","")

I like this solution of yours better.

 

[navic]

Column C and Column F is your "Result" column

I have an extra question.
I still try to avoid auxiliary 'C' and 'F' columns in which 'break' is.

So I want to subtract time and reset after 10 minutes.
But not to find a way.
For example, in the 'B12' cell expected result is 0:11 minutes.

Is there a possibility for this solution?

 

[navic]

I have an extra question.
I still try to avoid auxiliary 'C' and 'F' columns in which 'break' is.
So I want to subtract time and reset after 10 minutes.
But not to find a way.

I opened a new thread.

Subtract time

I am opening a new thread related to this topic https://chandoo.org/forum/threads/set-break-after-certain-time.46753/ This is a situation where I want to subtract hours every 10 minutes but without an helper column? Is that possible? Attached file.

chandoo.org