C D E F G H I J K L M N
06/23/23 9:00 13:00 4:00 9:03 12:22 3:19 0 -0:41 (=K11-G11)
06/23/23 9:00 13:00 4:00 9:03 12:22 3:19 0 -0:03 (=K11-G11) actually 302847222
The first row of data is from one spreadsheet. The second row, the same exact data was entered on to a different workbook, and the formula in Column N gives a different result. I have checked and rechecked all of the various calculations and formats and cannot find any differences, but each time I enter the data, the result in Column N is -0:41 in the one spreadsheet, and -0:03 on the other. I realize that it is actually the same result with a different format, but want to know why it just won't appear the same way. Is it possible that the spreadsheets were created using a different version of Excel?
06/23/23 9:00 13:00 4:00 9:03 12:22 3:19 0 -0:41 (=K11-G11)
06/23/23 9:00 13:00 4:00 9:03 12:22 3:19 0 -0:03 (=K11-G11) actually 302847222
The first row of data is from one spreadsheet. The second row, the same exact data was entered on to a different workbook, and the formula in Column N gives a different result. I have checked and rechecked all of the various calculations and formats and cannot find any differences, but each time I enter the data, the result in Column N is -0:41 in the one spreadsheet, and -0:03 on the other. I realize that it is actually the same result with a different format, but want to know why it just won't appear the same way. Is it possible that the spreadsheets were created using a different version of Excel?