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

#### DougStroud

##### Well-known Member
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
ABCDEFGHI
1FairfaxThuBreakFriBreakSatBreakSunBreak
2Employee12/1512/1612/1712/18
3Doug9-99-99-99-6
4Brian6-9
5JustinOff8-5Snow
6Eamonn6:30-9Signs
7Aaron1-99-6
8Matt
9TojhOff4-98-5Skate2-7
10
11
12Breannyn4-910-6Shoes10-5Office
13Christian1-910-5
14Zack3-93-98-5
15Chris R.6-9Floor
16Ben B.
17DustinOff4-91-99-6
18Christi5-95-912-5
19Troy
20Justin Murray10-610-7
Dec 8-14

Thanks,

Doug

### Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Replies
11
Views
323
Replies
2
Views
303
Replies
43
Views
2K
Replies
3
Views
155
Replies
8
Views
415