Please see below data pulled off a system.
Data gives a date and time which I converted to simply HOUR and then the transaction figures. As seen in C2 and C3 there were two transaction amounts (16.76 and 15.00 ) at 09:23:02.
Problem is when I want to create a pivot to see total transaction...