Here's a weird one that I'm hoping someone can resolve or suggest a workaround. I'm using date and time stamps to match certain rows of data across multiple sheets. It's fairly straightforward and works fine for thousands of rows of data with one exception.
As further detail, the date and time are entered as values and the cells formatted to display as mm/dd/yyyy hh:mm:ss. The way I derive the date and time is by adding a date value to a time value. With a few thousand rows of data matching up with no problem, I'm having an issue with one particular time, namely 10/01/2015 21:23:39. The serial date-time for this is 42278.89142. The problem is that whenever I add any whole number to 0.89142 it changes to x.8914199999. This doesn't match the results in the other sheets, which properly have the serial-date time as 42278.89142. I've even tried to round the result of adding 42278 + .89142 to the 5th decimal, but it still results in .8914199999.
Excel 2013 (15.0.4763.1002) MSO (15.0.4763.1003) 64-bit
As further detail, the date and time are entered as values and the cells formatted to display as mm/dd/yyyy hh:mm:ss. The way I derive the date and time is by adding a date value to a time value. With a few thousand rows of data matching up with no problem, I'm having an issue with one particular time, namely 10/01/2015 21:23:39. The serial date-time for this is 42278.89142. The problem is that whenever I add any whole number to 0.89142 it changes to x.8914199999. This doesn't match the results in the other sheets, which properly have the serial-date time as 42278.89142. I've even tried to round the result of adding 42278 + .89142 to the 5th decimal, but it still results in .8914199999.
Excel 2013 (15.0.4763.1002) MSO (15.0.4763.1003) 64-bit