Calculate the number of people working w/in a range of hours

[DougStroud]

Here goes- I have to write a weekly schedule. What I would like to do is see the number of people that are working within a range of hours.
The example would be: from 8-12 = 3, 12-4 = 5, 5-9 = 3.

Can this be accomplished.

Schedule FF_2005.xls
	A	B	C	D	E	F	G	H	I
1	Fairfax	Thu	Break	Fri	Break	Sat	Break	Sun	Break
2	Employee	12/15		12/16		12/17		12/18
3	Doug	9-9		9-9		9-9		9-6
4	Brian			6-9
5	Justin			Off		8-5	Snow
6	Eamonn	6:30-9	Signs
7	Aaron					1-9		9-6
8	Matt
9	Tojh	Off		4-9		8-5	Skate	2-7
10
11
12	Breannyn			4-9		10-6	Shoes	10-5	Office
13	Christian					1-9		10-5
14	Zack	3-9		3-9		8-5
15	Chris R.	6-9	Floor
16	Ben B.
17	Dustin	Off		4-9		1-9		9-6
18	Christi			5-9		5-9		12-5
19	Troy
20	Justin Murray	10-6		10-7
Dec 8-14

Thanks,

Doug