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]

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

Mike

You're welcome. Thanks for the feedback!