Scheduling

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?