Strange date format anomaly

[normpam]

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?

 

[awoohaw]

The way you posted this makes it look like you are doing this subtraction: -0:41 - 12:22. What time numbers are you subtracting?

Can yo post the data as a table, or use the xl2bb add in (link below)?

if not at tell us the actual numbers/values of what you want to subtract.

Thanks in advance.

Book1
	C	D	E	F	G	H	I	J	K	L	M
1	C	D	E	F	G	H	I	J	K	L	M
2
3	2023-06-23	09:00	13:00	04:00	09:03	12:22	03:19	0	-0:41		(=K11-G11)
4
5	2023-06-23	09:00	13:00	04:00	09:03	12:22	03:19	0	-0:03		(=K11-G11)
Sheet2

 

[normpam]

The way you posted this makes it look like you are doing this subtraction: -0:41 - 12:22. What time numbers are you subtracting?

Can yo post the data as a table, or use the xl2bb add in (link below)?

if not at tell us the actual numbers/values of what you want to subtract.

Thanks in advance.

Book1
	C	D	E	F	G	H	I	J	K	L	M
1	C	D	E	F	G	H	I	J	K	L	M
2
3	2023-06-23	09:00	13:00	04:00	09:03	12:22	03:19	0	-0:41		(=K11-G11)
4
5	2023-06-23	09:00	13:00	04:00	09:03	12:22	03:19	0	-0:03		(=K11-G11)
Sheet2

Sorry... I screwed up! the subtraction in this case should be subtracting column F from column I