Hey guys,

Below is a table I've created to calculate the total man hours at my office based on a schedule set.
Name Time in Time out Break (Out) Break (In 10am-11am 11am-12pm 12pm-1pm 1pm-2pm 2pm-3pm 3pm-4pm 4pm-5pm
Mr A 9:00 17:00 12:00 14:00 X1 X2 X3 X4 X5 X6 X7

For example, on "X1", I have =MIN(C2,11/24)-MAX(B2,10/24).
So my end result so far will be like this:

Name Time in Time out Break (Out) Break (In 10am-11am 11am-12pm 12pm-1pm 1pm-2pm 2pm-3pm 3pm-4pm 4pm-5pm
Mr A 9:00 17:00 12:00 14:00 1:00 1:00 1:00 1:00 1:00 1:00 1:00

Now, what I need it to display is 0:00 or "Break" for (12pm-1pm) & (1pm-2pm) since Mr A's break time is between 12pm-2pm.

This is the end result I need it to display:

Name Time in Time out Break (Out) Break (In 10am-11am 11am-12pm 12pm-1pm 1pm-2pm 2pm-3pm 3pm-4pm 4pm-5pm
Mr A 9:00 17:00 12:00 14:00 1:00 1:00 0:00 0:00 1:00 1:00 1:00

What formula should I be using to get this result?