Using Concatenated Date&Time

See attached for reference.

Hello,

I'm trying to use Column D as the X-Axis in a pivot table where the Y-Axis will be Column N.

The problem I am having is that Column D, on the pivot table, behaves only as a date and not a date and time.
I have more than one data point on some days so this needs to be distinguished. So instead of creating two points it creates a single point with the data points summed together.

I've tried searching around; I fear I am not asking the write question so I have made a new post.
This is really the first time I've tried using a pivot table so if you have any advice please hit me with it.

Post with additional questions if you have any.


-SMCC

Yes, that should be good to get me started. Thank you. There are a few more modifications I want to make to it but I want to try and solve it myself first. Thanks!

You are welcome and thanks