Excel calculation wrong ... sometimes, query

[tezza]

Hi all

I've got a table of dates and times but when I add a column to take the end time away from the start time, I don't always get the correct result.

I've put the wrong answer as general format to try and understand it better.

On a sheet of 2706 lines, 86 are wrong.

TimesheetExtract.csv
	X	Y	Z	AA
1	Date of Call	Call Start Time	Call End Time	Call Duration
2	03/02/2024	0.416666667	0.625	0
15	20/02/2024	12:30	17:30	5:00
TimesheetExtract

Cell Formulas
Range	Formula
AA2	AA2	=[@[Call End Time]]-[@[Call End Time]]

However, if I copy and paste values and do end - start time, I get the right answer.

TimesheetExtract.csv
	A	B	C	D
1	Date of Call	Call Start Time	Call End Time	Call Duration
2	03/02/2024	0.416666667	0.625	0.208333333
3	20/02/2024	12:30:00	17:30:00	05:00:00
Sheet2

Cell Formulas
Range	Formula
D2:D3	D2	=C2-B2

Any ideas?

 

[KRice]

You’re subtracting end time from end time. Try:

=[@[Call End Time]]-[@[Call Start Time]]

 

[tezza]

 

[KRice]

It happens to all of us...