Thread: [Solved] Formula Additions Incorrect
View Single Post
 
Old 09-21-2012, 10:11 AM
PaulPCoker PaulPCoker is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Sep 2012
Posts: 5
PaulPCoker is on a distinguished road
Default

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.
Reply With Quote