+ Reply to Thread
Results 1 to 2 of 2

creating a pivot table from employee attendance data

  1. #1
    Registered User
    Join Date
    01-18-2017
    Location
    KSA
    MS-Off Ver
    2016
    Posts
    1

    creating a pivot table from employee attendance data

    hello,

    I have attendance data (empNumber,date,time_in,time_out)
    EmployeeNumber Date Time InOrOut
    111 1/1/2017 7:55am in
    222 1/1/2017 7:58am in
    111 1/1/2017 2:17pm out
    222 1/1/2017 2:30pm out
    111 1/2/2017 7:54am in
    222 1/2/2017 7:57am in
    111 1/2/2017 2:18pm out
    222 1/2/2017 2:30pm out

    When I generate a pivot table, it will show the sum values of Time. it will tell me that the employee has 2 entries on that date. but I want it to show me the actual time.

    like this
    EmployeeNumber Date-1 Date-2 Date-N
    111 1/1/2017 1/2/2017 ...
    |TimeIn 7:55am 7:54am
    |TimeOut 2:17pm 2:18pm
    222
    |TimeIn 7:58am 7:57pm
    |TimeOut 2:30pm 2:30pm

    how can I achieve this?
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: creating a pivot table from employee attendance data

    Hello,
    You need a little remodel your data. Then add a calculated field to the PivotTable and ready.
    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)

Similar Threads

  1. Employee Attendance help please
    By fredek in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-22-2016, 12:06 PM
  2. Creating a Pivot Table using Data Table in different file?
    By JasonMcQueen in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-13-2016, 11:56 AM
  3. Creating employee attendance
    By hidetoshi76 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-28-2015, 12:45 PM
  4. Attendance & Point WS - Need easy buttons to remove employee's and their data.
    By SRWilson87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2015, 11:43 AM
  5. Need Help - AutoCalculate Attendance Points for employee attendance records
    By switzd0d in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-17-2015, 03:00 PM
  6. [SOLVED] Creating a attendance record for office employee?
    By benn371 in forum Excel General
    Replies: 3
    Last Post: 06-24-2013, 10:53 AM
  7. Summarize employee attendance data on a weekly basis
    By Hanr3 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-05-2006, 12:00 PM

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