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

DougStroud

Well-known Member
Joined
Aug 16, 2005
Messages
2,961
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
 

Some videos you may like

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).

Watch MrExcel Video

Forum statistics

Threads
1,118,760
Messages
5,574,084
Members
412,566
Latest member
TexasTony
Top