+ Reply to Thread
Results 1 to 1 of 1

Data Analysis- advanced pivot functions for employee analysis

  1. #1
    Registered User
    Join Date
    05-10-2013
    Location
    ohio
    MS-Off Ver
    Excel 2010
    Posts
    1

    Unhappy Data Analysis- advanced pivot functions for employee analysis

    I am stuck on this data analysis. I finished all the way to step 3. these are my instructions below.

    1. Convert the Time In and Time Out columns from text to actual time.
    2. Using the Date In column and the formatted Time In & Time Out columns, create 2 new columns called Date/Time In & Date/Time Out
    3. Create a new table called "HOURLY COUNTS".
    4. For each hour of the day, beginning with 6AM and ending with 5AM (gaming day), count the number of dealers that are on staff for each date.
    5. Average the number of employees for each Day of the Week.
    6. Create a line chart that graphs the average number of employees by hour for each Day of the Week.

    The data for the dates were in the wrong format, So I added two new fields. Excel is reading those new fields as a text still but I am able to get hours out of it.

    I am stuck on part number 4, I am not sure how to get a count for every hour "dealers" worked when the information given is time in and out and hours worked. ATTACHED IS THE FILE.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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