Results 1 to 3 of 3

Schedule count by shift and date...

Threaded View

  1. #1
    Registered User
    Join Date
    07-04-2012
    Location
    Athens
    MS-Off Ver
    Excel 2007
    Posts
    8

    Schedule count by shift and date...

    Hello again,
    Here s the deal.... I have a table that describes a weekly schedule of a call center dpt.
    For each agent there are several lines, each of one describes by task for an agent (emp id is the key) the start date, the stop date, the start time, the stop time, the assigned task (including breaks...) and the agents team during a day.
    As a result there are many lines that describe an agents day shift.

    What i am trying to do is to count the number of agents that are assigned to each shift for each team...

    I believe that what i need is the earliest assigned task start time and the latest assigned task stop time for each agent for each day....and then count it with date and team (emp class) criteria


    any ideas on how to retrieve this out of my original data?...

    Thank you all in advance
    Attached Files Attached Files

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