Subtract two times (incl. holidays and excl. weekends)

I am trying to subtract two times from either and the purpose is to know the difference between the two times within an operational work day (what I have called "vacation" on the attachment).

I have tried several formulas which include WORDAYS and NETWORKDAYS.INTL but cannot figure it out. I do not think workdays is appropriate as the clock should roll 24/7 in exception to what is stated within the 'vacation table'.

subtract two times with holidays.xlsx

Please see the attachment. If you find the right formula your Column C should equal my Column D. The 'vacation table' will not always be 24 hours.

in rows 17 and below, why are you adding 2 hours?
Start time is after the start of vacation so I thought the formula should return 0 but you seems to add 2 hours.

This formula works through row 16.

Formula:

Please Login or Register  to view this content.

After that it returns numbers different than the expected results.

From row 17 downward I cannot see how you come up with the values you do. Can you clarify further?

BTW: Both files appear to be identical.

Row\Col	A	B	C	D	E	F	G	H
5	Start Time	End Time	Formula	What it should be (1.0 = 1 Day)			Start of Vacation	End of Vacation
6	7/30/15 10:00	7/31/15 8:50	0.95	0.95			8/1/15 2:00	8/2/15 2:00
7	7/30/15 11:50	7/31/15 8:15	0.85	0.85
8	7/31/15 3:40	7/31/15 8:20	0.19	0.19
9	7/31/15 3:43	7/31/15 9:17	0.23	0.23
10	7/31/15 4:29	7/31/15 10:45	0.26	0.26
11	7/31/15 4:35	7/31/15 12:30	0.33	0.33
12	7/31/15 7:26	7/31/15 10:50	0.14	0.14
13	7/31/15 10:27	7/31/15 13:05	0.11	0.11
14	8/2/15 5:01	8/2/15 8:35	0.15	0.15
15	7/31/15 21:27	8/2/15 10:15	0.53	0.53
16	7/31/15 16:17	8/2/15 8:51	0.69	0.69
17	8/1/15 5:53	8/2/15 12:10	0.42	0.51
18	8/1/15 5:53	8/2/15 10:50	0.37	0.45
19	8/1/15 8:35	8/2/15 13:45	0.49	0.57
20	8/1/15 10:16	8/2/15 14:05	0.50	0.59

I'll see what I can do. Can you accommodate helper columns / cells?

Edit: I can not come up with anything else. I am calling for help.

Another edit: This is slightly shorter. Array-enter and fill down.

Formula:

Please Login or Register  to view this content.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

The array function offered above seems to operate perfectly. I would recommend you use that.