Pivot table time value help

[BalloutMoe]

Hello all, I have two table I get data from a CSV file that contains employees name, ID, Clock in and clock out times. I was wondering how can I just get the actual time in the values column as the time in the table. Its counting the value and when I change the number format it just shows the times as 12:00:00 am which is not correct. I attached a picture with the pivot table. Column B is the clock in, which most employees have 8:00 am and clock out is about 6:00 pm Please let me know how can this be done or any help would be appreciated. Thank you

 

[BalloutMoe]

Bump any help? Thanks

 

[Sufiyan97]

Change the values field from Count to Sum

 

[BalloutMoe]

Change the values field from Count to Sum

Sufiyan, I tried that and it says "We can't summarize this field with Sum because it's not supported calculation for Date data types." Never mind, I just pressed okay and it worked. smh Thank you

 

[Sufiyan97]

If you don't want to calculate the time and just want to see the Summarized Pivot table
Just move time from Values to Rows and format cells with "m/d/yyyy h:mm"

 

[Sufiyan97]

Sufiyan, I tried that and it says "We can't summarize this field with Sum because it's not supported calculation for Date data types." Never mind, I just pressed okay and it worked. smh Thank you

That may be because you have date and time together.

 

[BalloutMoe]

That may be because you have date and time together.

Okay I will take a look thank you for your help, when I move them to the rows it displays everyone's time clock not just the specific employee for that date.