Never had much to do with excel before, but am trying to work out a problem with a roster system. On sheet 1, the roster looks something like this

Person a 700
Person b 1430
Person c 730
person d 1230
Person e 700
Person f 1430
Person g ARL
Person h 930
Person i 930
Person j 700

column A being the persons name and column B is the time the shift starts. On sheet 2, I then want to retrieve the info and group it in time slots like so

Person a 700
Person c 730
Person e 700
Person j 700


Person h 930
Person i 930


Person b 1430
person d 1230
Person f 1430

so it can be printed off for a daily allocation sheet.

Any help would be greatly appreciated.

Thanx