I am adding rows/columns in my payroll spreadsheet. The columns on the right are supposed to be the same as the columns on the left. However, sometimes they do not always come out the same and I cannot see why. Can you take a look at the sheet I have attached that is not coming out to this to tell me why.
Thanks much for your help!
Cathy

Attached Files

payroll spreadsheet error.xlsx (14.3 KB, 14 views)

Hi

I fail to see what your problem is. Could you please be a bit more specific ?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

The grand total at the bottom for the in and out totals in col K should be the same as the classification totals on the left in col L. Most of the time these come out exact but occasionally they are a few cents off. The totals for each row match exactly yet sometimes to grand total at the bottom is a few cents off.
Cathy

It's a case of round-off error. Expand your column K and L numbers to four decimal places, to see it. To get the same sum for both columns you need to truncate the trailing "333333333333333" in those time values that don't come out even.