Bracket Error

[HappyChappy]

Payslip.xlsx
	A	B	C	D	E	F
1	Day	Date	Start Time	Finish Time	Hours Worked	Hours Worked
2			Days Hours
3	Monday	12/02/2024	07:00	17:00	10:00:00	10.00
19.02.24

Cell Formulas
Range	Formula
E3	E3	=IF(OR(C3="",D3=""),"",D3-C3)
F3	F3	=IF(OR(C3="",D3=""),"",E3*24)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C3:D10	Cell Value	>0	text	NO

if(or(c3="",d3=""),"",(c3-d3)*24))

i know its an issue with brackets but can't get it to work, want to do away with col E to tidy things up

 

[HappyChappy]

worked it out thank-you.....

 

[HappyChappy]

Payslip.xlsx
	A	B	C	D	E	F	G	H	I
1	Day	Date	Start Time	Finish Time	Hours Worked	Hours Worked	Break	Break	Hours Minus Break
2			Days Hours
3	Monday	12/02/2024	07:00	17:00		10.00	00:45:00	0.75	23:15:00
19.02.24

Cell Formulas
Range	Formula
F3	F3	=IF(OR(C3="",D3=""),"",D3-C3)*24
G3	G3	=IF(OR(C3="",D3=""),"",1/32)
H3	H3	=IF(OR(D3="",C3=""),"",G3*24)
I3	I3	=IF(OR(C3="",D3=""),"",F3-(G3))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C3:D10	Cell Value	>0	text	NO

worked out initial problem but generated another from i col i should show 9:15 but instead shows 23:15

 

[Peter_SSs]

worked out initial problem

I'm not sure you have. If C3 or D3 is blank then your F3 formula will return an error. It should be

=IF(OR(C3="",D3=""),"",(D3-C3)*24)

but generated another from i col i should show 9:15 but instead shows 23:15

Try this in I3

=IF(OR(C3="",D3=""),"",F3/24-G3)

or

=IF(OR(C3="",D3=""),"",D3-C3-G3)

BTW, if you are still looking for help in a thread, probably best to remove the "Mark as solution". Many helpers will not even look at your thread if they see it already has a solution.