I have kind of given up trying to manipulate the numbers. Some cannot be reconciled.
My logbook adds up correctly and that is the final number. I will have to figure out a way to explain that in an interview. But anyone can sit down with any of my three logbooks and the columns add up properly. But when I put my airplanes into airline apps the final numbers don't equal the final total in my logbooks.
So I simply put in the correct number and if the total is not right I can assume that my logbook is the controlling document. After all, I log every single leg.