You'll need to split the times, as that's what you'll be analysing in a Pivot Table.
I split the dates like this.
Cell N1 = A1 ---Then format the cell to General - so you see a number like 41276.9375
Cell O1 =ROUNDDOWN(N1,0) ----This will give you the date - so format this column back to a Date format
Cell P1 =N1-O1 ---- This will give you the time, so format this using Custom - "HH:MM"
Copy and Paste Values Column O & P - into Column O&P (so you are hardcoding the formula's)
Then Paste O&P into A&B