populate cells based on table criteria.

[Sandyclaws]

Hi, I have been trying to find a neat way to do this but i haven't been successful.

I have this sheet

	Monday in	Monday out	Tuesday in	Tuesday Out
Name1	05:00	13:00	05:00	13:00
Name2	12:00	18:00	08:00	17:00
Name3	12:00	18:00
Name4			11:00	15:00
Name5	06:00	11:00	07:00	12:00

<tbody>
</tbody>

What i'm trying to do is check who works after 05:00 but before 12:00 and add them to a list 1 name per row for the "AM" workers and if they work after 12:00 put them in a list for the "PM" workers.

example

AM	Name1
	Name5
PM	Name2
	Name3

<tbody>
</tbody>

Unfortunately i haven't been successful, the best i could do is come up with the formula that will check wether they work morning or evening and apply it to every cell. Which means that for 17 employees i have to allocate 17 cells and replicate the formula 17 times to check each cell individually which leaves me with a lot of blank cells because they have days off etc.

Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
Name1		Name1	Name1		Name1	Name1
Name3	Name3
Name5
	Name6

<tbody>
</tbody>

While i'm trying to make it write the results continuously like

Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
Name1	Name3	Name1	Name1		Name1	Name
Name3	Name6
Name5

<tbody>
</tbody>

Any help would be appreciated.