Pivot Chart Reporting 0's on time totals

Hi everyone. So I have a very large data set of agent aux metrics for a call center. With most of our reports I can make a pivot table with no issue and it will give totals of the time in each aux for each agent. Easy right? OK. So I got this data from a new report, and I have copied and pasted it as text and formatted it all manually including making sure the time totals were [h]:mm:ss, I made sure there were no empty cells, I retyped all the headings since I originally copy and pasted them. But as soon as I make the pivot, it gives me the dates, it gives me the agents names and i can put them in filter and that seems to be all good. I have all the aux code names available to be used as column headings. But as soon as I try to put in values I get either a bogus count (which I dont even want a count but it gives the same 4 numbers every time for every column) or the sum comes out as 00:00:00. I am quite frustrated and dont know what to do. The file attached is a kind of weak example but this other report is on my work system so I cannot share it. Thank you in advance for your input!