+ Reply to Thread
Results 1 to 2 of 2

Rostering problem

  1. #1
    Registered User
    Join Date
    08-25-2005
    Location
    NSW, Australia
    Posts
    7

    Question Rostering problem

    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

  2. #2
    Registered User
    Join Date
    08-25-2005
    Location
    NSW, Australia
    Posts
    7
    Any suggestions?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1