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?
Bookmarks