Cross tab help

[marlylove]

I'm having an issue when I use the cross tab tool that I can't figure out. The input data looks like below and I'm using the Cross tab tool to group the data by Day going down and Time going across. So I would expect Day 01 Time 00:00 to be 0 and Day 01 Time 00:15 to be 19.91, however that's not the results after the cross tab tool (see second screenshot). It seems to only be incorrect on Day 1 and the other days are pulling correctly.  

I have attached my workflow and input files, can someone please help!

[PhilipMannering · Accepted solution]

Sorting by day and time ascending shows that you have two rows being summed up to get that 29.44 value. So it is working as expected.

[marlylove]

Yep, that it what is happening.  Thank you! Looks like it's being caused by the source data including 4/1 data.