I have an application where I am summarizing data in a database that is received from a time clock. The data has a record for each employee that has their ID and the date/time they clocked in. I need to produce a report that shows as:
Employee 5/2/2017 5/3/2017 5/4/2017 5/5/2017 5/6/2017
123 09:00 08:59 09:01 09:00 09:00
123 17:00 17:30 17:00 17:00 17:05
456 12:00 09:00 11:00 09:00 09:00
456 16:00 16:00 16:00 17:00 17:00
The 1st entry is the punch in time and the second is the punch out time. The data from the clock has the date/time format (05/02/2017 0900).
When I select the date as a VALUE in the Pivot table, I went to the Value Field Settings and choose Show Values as No Calculation and format the field as Time (13:00), the table shows as 00:00.
What am I doing wrong?
Here is a screenshot of my pivot table and the settings: https://www.dropbox.com/s/qm40hkgp8vk78kc/2017-05-10 Time Clock.png?dl=0
Employee 5/2/2017 5/3/2017 5/4/2017 5/5/2017 5/6/2017
123 09:00 08:59 09:01 09:00 09:00
123 17:00 17:30 17:00 17:00 17:05
456 12:00 09:00 11:00 09:00 09:00
456 16:00 16:00 16:00 17:00 17:00
The 1st entry is the punch in time and the second is the punch out time. The data from the clock has the date/time format (05/02/2017 0900).
When I select the date as a VALUE in the Pivot table, I went to the Value Field Settings and choose Show Values as No Calculation and format the field as Time (13:00), the table shows as 00:00.
What am I doing wrong?
Here is a screenshot of my pivot table and the settings: https://www.dropbox.com/s/qm40hkgp8vk78kc/2017-05-10 Time Clock.png?dl=0
