Converting raw data to pivot table/chart doesn't detect seconds

[GhostyIs1337]

Hey!

I'm in a bit of a pickle. So basically, I've got over 50,000 lines of columns that I have to convert to charts. And to test it out, I used a pivot table and chart. Everything works fine, but it doesn't detect seconds.

So, what I did was:

1. In raw data convert the text to columns as DATE: MDY
2. Created a pivot table/chart

Now, everything works as expected, I can select different kinds of names, days, time of day, etc., but what I can't select is seconds.

What I want to filter it through are seconds as well. Because stuff happens per second.

Note: the days, hours and minutes were automatically added by Excel.

I'm using the latest version of Excel.

Did I do something wrong? Can you help me?

Thanks in advance!

 

[GhostyIs1337]

Never mind, I fixed it on my own. The seconds were named "Create date".