Conditional Formatting, Formula equals <>0

[Queeza]

Hello
I'm having trouble understanding why the conditional formatting formula =C$7-C$25<>0 is working for some column entries but not others. the conditional formatting is to highlight that the entries of time to project numbers equals the amount of time worked. The finish time is 15:03:30 just so the hours worked = 8.06 but that should not be a factor.
Any help with this would be greatly appreciated.
Thanks
Steve

Timesheet.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
2		SAT		SUN		MON		TUE		WED		THU		FRI
3	START TIME	06:30		06:30		06:30		06:30		06:30		06:30		06:30
4	START LUNCH	12:30		12:30		12:30		12:00		12:30		12:00		12:30
5	FINISH LUNCH	13:00		13:00		13:00		12:30		13:00		12:30		13:00
6	FINISH TIME	15:03:30		15:03		15:03		15:03		15:03		15:03		15:03
7	HOURS : MIN WORKED	8.06		8.06		8.06		8.06		8.06		8.06		8.06
8	PROJECT NUMBER		PCC		PCC		PCC		PCC		PCC		PCC		PCC
9	A1	8.06		7.06		1.00		6.00		6.06		4.00		4.06
10	B2			1.00		7.06		1.00		1.00		1.00		1.00
11	B3							1.06		1.00		1.00		1.00
12	B4											2.06		2.00
13	B5
14	B6
15
16
17
18
19
20
21
22
23
24
25	TOTALS	8.06		8.06		8.06		8.06		8.06		8.06		8.06
Sheet1

Cell Formulas
Range	Formula
C7,E7,G7,I7,K7,M7,O7	C7	=ROUND((C4-C3+C6-C5)*24,2)
C8	C8	=IF(ISBLANK($R$1),"",$R$1-6)
E8	E8	=IF(ISBLANK($R$1),"",$R$1-5)
G8	G8	=IF(ISBLANK($R$1),"",$R$1-4)
I8	I8	=IF(ISBLANK($R$1),"",$R$1-3)
K8	K8	=IF(ISBLANK($R$1),"",$R$1-2)
M8	M8	=IF(ISBLANK($R$1),"",$R$1-1)
O8	O8	=IF(ISBLANK($R$1),"",$R$1)
C25,O25,M25,K25,I25,G25,E25	C25	=SUM(C9:C24)

 

[HongRu]

try to add round fuction on TOTALS.
C25

=ROUND(SUM(C9:C24),2)

then copy to O25,M25,K25,I25,G25,E25

or
repalce

=C$7-C$25<>0

by

=C$7<>C$25

 

[HongRu]

maybe this is why.

Floating-point arithmetic may give inaccurate result in Excel - Microsoft 365 Apps

Discusses that floating-point arithmetic may give inaccurate results in Excel.

learn.microsoft.com

 

[Queeza]

Thanks HongRu the rounding did the trick. With both the Hours: Min Worked and Totals rows ROUNDED the conditional formatting now works.
Thanks again.
Steve