Counting Help

[mstevens157]

I have the following table. It shows by day and by operating room the ealiest time a procedure started and the latest time a procedure ended. I am trying to figure out how I can count the number of rooms thet there operating at any given time. Something like the second table (I just put the totals in as examples they are not right). Any help would be appreciated.

Excel 2007

	A	B	C	D
1	Date	Room	Min	Max
2	11/1/2010	OR 1	8:00	19:30
3	11/1/2010	OR 2	8:37	16:55
4	11/1/2010	OR 3	6:55	14:20
5	11/1/2010	OR 4	7:57	18:03
6	11/1/2010	OR 5	7:58	18:03
7	11/1/2010	OR 6	8:11	16:07
8	11/1/2010	OR 7	10:12	16:33
9	11/1/2010	OR 8	7:06	17:07
10	11/2/2010	OR 1	8:33	12:59
11	11/2/2010	OR 2	8:30	13:42
12	11/2/2010	OR 3	6:55	11:35
13	11/2/2010	OR 4	6:41	14:10
14	11/2/2010	OR 5	9:42	12:46
15	11/2/2010	OR 6	7:13	13:12
16	11/2/2010	OR 7	7:45	12:06
17	11/2/2010	OR 8	7:15	12:25
18	11/3/2010	OR 1	8:55	17:53
19	11/3/2010	OR 2	7:02	15:56
20	11/3/2010	OR 3	6:50	15:06
21	11/3/2010	OR 4	7:12	12:10
22	11/3/2010	OR 5	8:24	15:05
23	11/3/2010	OR 6	9:58	19:09
24	11/3/2010	OR 7	7:04	15:40
25	11/3/2010	OR 8	8:08	14:56
26	11/4/2010	OR 1	9:35	14:04
27	11/4/2010	OR 2	7:03	15:26
28	11/4/2010	OR 3	8:32	17:24
29	11/4/2010	OR 4	7:56	14:12
30	11/4/2010	OR 5	10:11	14:04
31	11/4/2010	OR 6	8:55	14:10
32	11/4/2010	OR 7	12:11	12:49

<TBODY>
</TBODY>

Excel 2007

	K	L	M	N
0700 - 1200	1200-1500	1500-1700

<COLGROUP><COL><COL><COL><COL><COL></COLGROUP><THEAD>
</THEAD><TBODY>
[TD="align: center"]2[/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]11/1/2010[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]11/2/2010[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]11/3/2010[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]

</TBODY>

Combined​

 

[T. Valko]

I have the following table. It shows by day and by operating room the ealiest time a procedure started and the latest time a procedure ended. I am trying to figure out how I can count the number of rooms thet there operating at any given time. Something like the second table (I just put the totals in as examples they are not right). Any help would be appreciated.



Excel 2007

	K	L	M	N
2	0700 - 1200	1200-1500	1500-1700
3
4
5

<TBODY>
[TD="align: right"][/TD]

[TD="align: right"]11/1/2010
[/TD]
[TD="align: right"]8
[/TD]
[TD="align: right"]8
[/TD]
[TD="align: right"]5
[/TD]

[TD="align: right"]11/2/2010
[/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]8
[/TD]

[TD="align: right"]11/3/2010
[/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"]5
[/TD]

</TBODY>

Combined​

You need to refine your summay criteria as the times overlap. For example, if a procedure starts or ends at 1200 which column should that be included in? Should it be included in column L or column M?

You should define the time ranges something like this:

0700 to 1159
1200 to 1459
1500 to 1659

Or:

0701 to 1200
1201 to 1500
1501 to 1700

Also, they should be in separate cells.

Book1
	K	L	M	N
2	_	7:00	12:00	15:00
3	_	11:59	14:59	16:59
4	11/1/2012	8	8	5
Sheet1

 

[mstevens157]

OK but after doing that how do I calulate the totals?

 

[T. Valko]

OK but after doing that how do I calulate the totals?

Can you show us what results you expect?

 

[mstevens157]

Here is a weeks worth of data and what I would like the results to look like.

Excel 2007

	A	B	C	D	E

<COLGROUP><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD>
</THEAD><TBODY>
[TD="align: center"]1[/TD]
[TD="align: center"]Date[/TD]
[TD="align: center"]Room[/TD]
[TD="align: center"]Min[/TD]
[TD="align: center"]Max[/TD]
[TD="align: center"]Total[/TD]

[TD="align: center"]2[/TD]
[TD="align: center"]11/01/10[/TD]
[TD="align: center"]OR 1[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]19:30[/TD]
[TD="align: center"]11.50[/TD]

[TD="align: center"]3[/TD]
[TD="align: center"]11/01/10[/TD]
[TD="align: center"]OR 2[/TD]
[TD="align: center"]8:37[/TD]
[TD="align: center"]16:55[/TD]
[TD="align: center"]8.30[/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]11/01/10[/TD]
[TD="align: center"]OR 3[/TD]
[TD="align: center"]6:55[/TD]
[TD="align: center"]14:20[/TD]
[TD="align: center"]7.42[/TD]

[TD="align: center"]5[/TD]
[TD="align: center"]11/01/10[/TD]
[TD="align: center"]OR 4[/TD]
[TD="align: center"]7:57[/TD]
[TD="align: center"]18:03[/TD]
[TD="align: center"]10.10[/TD]

[TD="align: center"]6[/TD]
[TD="align: center"]11/01/10[/TD]
[TD="align: center"]OR 5[/TD]
[TD="align: center"]7:58[/TD]
[TD="align: center"]18:03[/TD]
[TD="align: center"]10.08[/TD]

[TD="align: center"]7[/TD]
[TD="align: center"]11/01/10[/TD]
[TD="align: center"]OR 6[/TD]
[TD="align: center"]8:11[/TD]
[TD="align: center"]16:07[/TD]
[TD="align: center"]7.93[/TD]

[TD="align: center"]8[/TD]
[TD="align: center"]11/01/10[/TD]
[TD="align: center"]OR 7[/TD]
[TD="align: center"]10:12[/TD]
[TD="align: center"]16:33[/TD]
[TD="align: center"]6.35[/TD]

[TD="align: center"]9[/TD]
[TD="align: center"]11/01/10[/TD]
[TD="align: center"]OR 8[/TD]
[TD="align: center"]7:06[/TD]
[TD="align: center"]17:07[/TD]
[TD="align: center"]10.02[/TD]

[TD="align: center"]10[/TD]
[TD="align: center"]11/02/10[/TD]
[TD="align: center"]OR 1[/TD]
[TD="align: center"]8:33[/TD]
[TD="align: center"]12:59[/TD]
[TD="align: center"]4.43[/TD]

[TD="align: center"]11[/TD]
[TD="align: center"]11/02/10[/TD]
[TD="align: center"]OR 2[/TD]
[TD="align: center"]8:30[/TD]
[TD="align: center"]13:42[/TD]
[TD="align: center"]5.20[/TD]

[TD="align: center"]12[/TD]
[TD="align: center"]11/02/10[/TD]
[TD="align: center"]OR 3[/TD]
[TD="align: center"]6:55[/TD]
[TD="align: center"]11:35[/TD]
[TD="align: center"]4.67[/TD]

[TD="align: center"]13[/TD]
[TD="align: center"]11/02/10[/TD]
[TD="align: center"]OR 4[/TD]
[TD="align: center"]6:41[/TD]
[TD="align: center"]14:10[/TD]
[TD="align: center"]7.48[/TD]

[TD="align: center"]14[/TD]
[TD="align: center"]11/02/10[/TD]
[TD="align: center"]OR 5[/TD]
[TD="align: center"]9:42[/TD]
[TD="align: center"]12:46[/TD]
[TD="align: center"]3.07[/TD]

[TD="align: center"]15[/TD]
[TD="align: center"]11/02/10[/TD]
[TD="align: center"]OR 6[/TD]
[TD="align: center"]7:13[/TD]
[TD="align: center"]13:12[/TD]
[TD="align: center"]5.98[/TD]

[TD="align: center"]16[/TD]
[TD="align: center"]11/02/10[/TD]
[TD="align: center"]OR 7[/TD]
[TD="align: center"]7:45[/TD]
[TD="align: center"]12:06[/TD]
[TD="align: center"]4.35[/TD]

[TD="align: center"]17[/TD]
[TD="align: center"]11/02/10[/TD]
[TD="align: center"]OR 8[/TD]
[TD="align: center"]7:15[/TD]
[TD="align: center"]12:25[/TD]
[TD="align: center"]5.17[/TD]

[TD="align: center"]18[/TD]
[TD="align: center"]11/03/10[/TD]
[TD="align: center"]OR 1[/TD]
[TD="align: center"]8:55[/TD]
[TD="align: center"]17:53[/TD]
[TD="align: center"]8.97[/TD]

[TD="align: center"]19[/TD]
[TD="align: center"]11/03/10[/TD]
[TD="align: center"]OR 2[/TD]
[TD="align: center"]7:02[/TD]
[TD="align: center"]15:56[/TD]
[TD="align: center"]8.90[/TD]

[TD="align: center"]20[/TD]
[TD="align: center"]11/03/10[/TD]
[TD="align: center"]OR 3[/TD]
[TD="align: center"]6:50[/TD]
[TD="align: center"]15:06[/TD]
[TD="align: center"]8.27[/TD]

[TD="align: center"]21[/TD]
[TD="align: center"]11/03/10[/TD]
[TD="align: center"]OR 4[/TD]
[TD="align: center"]7:12[/TD]
[TD="align: center"]12:10[/TD]
[TD="align: center"]4.97[/TD]

[TD="align: center"]22[/TD]
[TD="align: center"]11/03/10[/TD]
[TD="align: center"]OR 5[/TD]
[TD="align: center"]8:24[/TD]
[TD="align: center"]15:05[/TD]
[TD="align: center"]6.68[/TD]

[TD="align: center"]23[/TD]
[TD="align: center"]11/03/10[/TD]
[TD="align: center"]OR 6[/TD]
[TD="align: center"]9:58[/TD]
[TD="align: center"]19:09[/TD]
[TD="align: center"]9.18[/TD]

[TD="align: center"]24[/TD]
[TD="align: center"]11/03/10[/TD]
[TD="align: center"]OR 7[/TD]
[TD="align: center"]7:04[/TD]
[TD="align: center"]15:40[/TD]
[TD="align: center"]8.60[/TD]

[TD="align: center"]25[/TD]
[TD="align: center"]11/03/10[/TD]
[TD="align: center"]OR 8[/TD]
[TD="align: center"]8:08[/TD]
[TD="align: center"]14:56[/TD]
[TD="align: center"]6.80[/TD]

[TD="align: center"]26[/TD]
[TD="align: center"]11/04/10[/TD]
[TD="align: center"]OR 1[/TD]
[TD="align: center"]9:35[/TD]
[TD="align: center"]14:04[/TD]
[TD="align: center"]4.48[/TD]

[TD="align: center"]27[/TD]
[TD="align: center"]11/04/10[/TD]
[TD="align: center"]OR 2[/TD]
[TD="align: center"]7:03[/TD]
[TD="align: center"]15:26[/TD]
[TD="align: center"]8.38[/TD]

[TD="align: center"]28[/TD]
[TD="align: center"]11/04/10[/TD]
[TD="align: center"]OR 3[/TD]
[TD="align: center"]8:32[/TD]
[TD="align: center"]17:24[/TD]
[TD="align: center"]8.87[/TD]

[TD="align: center"]29[/TD]
[TD="align: center"]11/04/10[/TD]
[TD="align: center"]OR 4[/TD]
[TD="align: center"]7:56[/TD]
[TD="align: center"]14:12[/TD]
[TD="align: center"]6.27[/TD]

[TD="align: center"]30[/TD]
[TD="align: center"]11/04/10[/TD]
[TD="align: center"]OR 5[/TD]
[TD="align: center"]10:11[/TD]
[TD="align: center"]14:04[/TD]
[TD="align: center"]3.88[/TD]

[TD="align: center"]31[/TD]
[TD="align: center"]11/04/10[/TD]
[TD="align: center"]OR 6[/TD]
[TD="align: center"]8:55[/TD]
[TD="align: center"]14:10[/TD]
[TD="align: center"]5.25[/TD]

[TD="align: center"]32[/TD]
[TD="align: center"]11/04/10[/TD]
[TD="align: center"]OR 7[/TD]
[TD="align: center"]12:11[/TD]
[TD="align: center"]12:49[/TD]
[TD="align: center"]0.63[/TD]

[TD="align: center"]33[/TD]
[TD="align: center"]11/04/10[/TD]
[TD="align: center"]OR 8[/TD]
[TD="align: center"]8:28[/TD]
[TD="align: center"]15:44[/TD]
[TD="align: center"]7.27[/TD]

[TD="align: center"]34[/TD]
[TD="align: center"]11/05/10[/TD]
[TD="align: center"]OR 1[/TD]
[TD="align: center"]6:40[/TD]
[TD="align: center"]14:56[/TD]
[TD="align: center"]8.27[/TD]

[TD="align: center"]35[/TD]
[TD="align: center"]11/05/10[/TD]
[TD="align: center"]OR 2[/TD]
[TD="align: center"]7:28[/TD]
[TD="align: center"]15:45[/TD]
[TD="align: center"]8.28[/TD]

[TD="align: center"]36[/TD]
[TD="align: center"]11/05/10[/TD]
[TD="align: center"]OR 3[/TD]
[TD="align: center"]8:20[/TD]
[TD="align: center"]16:50[/TD]
[TD="align: center"]8.50[/TD]

[TD="align: center"]37[/TD]
[TD="align: center"]11/05/10[/TD]
[TD="align: center"]OR 4[/TD]
[TD="align: center"]7:03[/TD]
[TD="align: center"]17:49[/TD]
[TD="align: center"]10.77[/TD]

[TD="align: center"]38[/TD]
[TD="align: center"]11/05/10[/TD]
[TD="align: center"]OR 5[/TD]
[TD="align: center"]8:27[/TD]
[TD="align: center"]13:08[/TD]
[TD="align: center"]4.68[/TD]

[TD="align: center"]39[/TD]
[TD="align: center"]11/05/10[/TD]
[TD="align: center"]OR 6[/TD]
[TD="align: center"]7:02[/TD]
[TD="align: center"]12:17[/TD]
[TD="align: center"]5.25[/TD]

[TD="align: center"]40[/TD]
[TD="align: center"]11/05/10[/TD]
[TD="align: center"]OR 7[/TD]
[TD="align: center"]8:43[/TD]
[TD="align: center"]12:29[/TD]
[TD="align: center"]3.77[/TD]

[TD="align: center"]41[/TD]
[TD="align: center"]11/05/10[/TD]
[TD="align: center"]OR 8[/TD]
[TD="align: center"]9:19[/TD]
[TD="align: center"]15:38[/TD]
[TD="align: center"]6.32[/TD]

</TBODY>

Sheet1​

Then the Results

Excel 2007

	H	I	J	K	L	M	N	O	P	Q	R	S

<COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD>
</THEAD><TBODY>
[TD="align: center"]26[/TD]
[TD="align: right"][/TD]
[TD="align: center"]6:30[/TD]
[TD="align: center"]8:00[/TD]
[TD="align: center"]9:00[/TD]
[TD="align: center"]10:00[/TD]
[TD="align: center"]11:00[/TD]
[TD="align: center"]12:00[/TD]
[TD="align: center"]13:00[/TD]
[TD="align: center"]14:00[/TD]
[TD="align: center"]15:00[/TD]
[TD="align: center"]16:00[/TD]
[TD="align: center"][/TD]

[TD="align: center"]27[/TD]
[TD="align: right"][/TD]
[TD="align: center"]7:59[/TD]
[TD="align: center"]8:59[/TD]
[TD="align: center"]9:59[/TD]
[TD="align: center"]10:59[/TD]
[TD="align: center"]11:59[/TD]
[TD="align: center"]12:59[/TD]
[TD="align: center"]13:59[/TD]
[TD="align: center"]14:59[/TD]
[TD="align: center"]15:59[/TD]
[TD="align: center"]16:59[/TD]
[TD="align: center"]> 17:00[/TD]

[TD="align: center"]28[/TD]
[TD="align: right"]11/1/2010[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]4[/TD]

[TD="align: center"]29[/TD]
[TD="align: right"]11/2/2010[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]

[TD="align: center"]30[/TD]
[TD="align: right"]11/3/2010[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]31[/TD]
[TD="align: right"]11/4/2010[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]

[TD="align: center"]32[/TD]
[TD="align: right"]11/5/2010[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]

</TBODY>

Sheet1​

 

[T. Valko]

Here is a weeks worth of data and what I would like the results to look like.

Excel 2007

	A	B	C	D	E
1	Date	Room	Min	Max	Total
2	11/01/10	OR 1	8:00	19:30	11.50
3	11/01/10	OR 2	8:37	16:55	8.30
4	11/01/10	OR 3	6:55	14:20	7.42
5	11/01/10	OR 4	7:57	18:03	10.10
6	11/01/10	OR 5	7:58	18:03	10.08
7	11/01/10	OR 6	8:11	16:07	7.93
8	11/01/10	OR 7	10:12	16:33	6.35
9	11/01/10	OR 8	7:06	17:07	10.02
10	11/02/10	OR 1	8:33	12:59	4.43
11	11/02/10	OR 2	8:30	13:42	5.20
12	11/02/10	OR 3	6:55	11:35	4.67
13	11/02/10	OR 4	6:41	14:10	7.48
14	11/02/10	OR 5	9:42	12:46	3.07
15	11/02/10	OR 6	7:13	13:12	5.98
16	11/02/10	OR 7	7:45	12:06	4.35
17	11/02/10	OR 8	7:15	12:25	5.17
18	11/03/10	OR 1	8:55	17:53	8.97
19	11/03/10	OR 2	7:02	15:56	8.90
20	11/03/10	OR 3	6:50	15:06	8.27
21	11/03/10	OR 4	7:12	12:10	4.97
22	11/03/10	OR 5	8:24	15:05	6.68
23	11/03/10	OR 6	9:58	19:09	9.18
24	11/03/10	OR 7	7:04	15:40	8.60
25	11/03/10	OR 8	8:08	14:56	6.80
26	11/04/10	OR 1	9:35	14:04	4.48
27	11/04/10	OR 2	7:03	15:26	8.38
28	11/04/10	OR 3	8:32	17:24	8.87
29	11/04/10	OR 4	7:56	14:12	6.27
30	11/04/10	OR 5	10:11	14:04	3.88
31	11/04/10	OR 6	8:55	14:10	5.25
32	11/04/10	OR 7	12:11	12:49	0.63
33	11/04/10	OR 8	8:28	15:44	7.27
34	11/05/10	OR 1	6:40	14:56	8.27
35	11/05/10	OR 2	7:28	15:45	8.28
36	11/05/10	OR 3	8:20	16:50	8.50
37	11/05/10	OR 4	7:03	17:49	10.77
38	11/05/10	OR 5	8:27	13:08	4.68
39	11/05/10	OR 6	7:02	12:17	5.25
40	11/05/10	OR 7	8:43	12:29	3.77
41	11/05/10	OR 8	9:19	15:38	6.32

<TBODY>
</TBODY>

Sheet1​

Then the Results

Excel 2007

	H	I	J	K	L	M	N	O	P	Q	R	S
26	6:30	8:00	9:00	10:00	11:00	12:00	13:00	14:00	15:00	16:00
27	7:59	8:59	9:59	10:59	11:59	12:59	13:59	14:59	15:59	16:59	> 17:00
28	8	8	8	8	8	8	8	8	7	7	4
29	5	7	8	8	8	7	3	1
30	4	7	8	8	8	8	7	7	6	2	2
31	2	5	6	7	7	8	7	7	3	1	1
32	4	7	8	8	8	8	5	5	4	2	1

<TBODY>
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"]11/1/2010
[/TD]

[TD="align: right"]11/2/2010
[/TD]

[TD="align: right"]11/3/2010
[/TD]

[TD="align: right"]11/4/2010
[/TD]

[TD="align: right"]11/5/2010
[/TD]

</TBODY>

Sheet1​

I don't see how you arrive at those results.

Explain how you get a count of 8 for 11/1/2010 and 6:30 - 7:59.

 

[mstevens157]

because i miss counted. Been staring at it so long it all runs rogether. It should be 4.

 

[T. Valko]

because i miss counted. Been staring at it so long it all runs rogether. It should be 4.

I'm not sure if these are the expected results but here's what I came up with...

Book1
	A	B	C
1	Dates	Start	End
2	11/1/2010	8:00	19:30
3	11/1/2010	8:37	16:55
4	11/1/2010	6:55	14:20
5	11/1/2010	7:57	18:03
6	11/1/2010	7:58	18:03
7	11/1/2010	8:11	16:07
8	11/1/2010	10:12	16:33
9	11/1/2010	7:06	17:07
Sheet1

Book1
	E	F	G	H
1	Date	From	To	Count
2	11/1/2010	6:30	7:59	4
3	_	8:00	8:59	7
4	_	9:00	9:59	7
5	_	10:00	10:59	8
6	_	11:00	11:59	8
7	_	12:00	12:59	8
8	_	13:00	13:59	8
9	_	14:00	14:59	8
10	_	15:00	15:59	7
11	_	16:00	16:59	7
12	_	17:00	17:00	4
Sheet1

This formula entered in H2 and copied down:

=SUMPRODUCT(--(Dates=E$2),SIGN((F2>=Start)*(F2<=End)+(G2>=Start)*(G2<=End)))

 

[T. Valko]

Note how the last time range (From - To) is the same:

Book1
	E	F	G	H
1	Date	From	To	Count
2	11/1/2010	6:30	7:59	4
3	_	8:00	8:59	7
4	_	9:00	9:59	7
5	_	10:00	10:59	8
6	_	11:00	11:59	8
7	_	12:00	12:59	8
8	_	13:00	13:59	8
9	_	14:00	14:59	8
10	_	15:00	15:59	7
11	_	16:00	16:59	7
12	_	17:00	17:00	4
Sheet1

 

[mstevens157]

Thanks for you help on this it worked like a charm. My apologies for not saying something sooner.

Mike