tidying up formulas

[HappyChappy]

Payslip.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	Day	Date	Start Time	Finish Time	Hours Worked	Break	Hours Minus Break	Servicing	Basic Hours	Basic Plus Servicing	Bonus Hours	Overtime		Adjust for 39 hours spread	Basic Pay	OverTime Pay	Bonus Pay	Breakdowns	Bonus Pay lost	Total Bonus Pay	Miles Travelled		Daily Total
2			Days Hours
3	Monday	12/02/2024			00:00:00		00:00:00		00:00:00	#VALUE!	00:00:00	00:00:00	00:00:00		#VALUE!	0.00	302.40		0.00	302.40		0.00	#VALUE!
12.02.24

Cell Formulas
Range	Formula
E3	E3	=D3-C3
F3	F3	=IF(C3&D3="","",2/32)
G3	G3	=IF(OR(C3="",D3=""),0,E3-(F3))
H3	H3	=IF(C3&D3="","",1/48)
I3	I3	=IF(OR(C3="",D3=""),0,E3-F3-H3-M3-N3)
J3	J3	=I3+H3
K3	K3	=IF(OR(C3="",D3=""),9,E3-F3-H3)
L3	L3	=IF(OR(C3="",D3=""),0,G3-J3)
M3	M3	=E3-G3
N3	N3	=IF(C3&D3="","",1/120)
O3	O3	=(J3*24)*A$14
P3	P3	=(L3*24)*A$15
Q3	Q3	=(K3*24)*A$16
S3	S3	=R3*A$16
T3	T3	=Q3-S3
V3	V3	=U3*A$17
W3	W3	=O3+P3+T3+V3

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

Cells with Data Validation
Cell	Allow	Criteria
R3:R10	List	=$A$19:$A$28

The sheet works fine when times are entered but looks messy when the times are not entered in c3 and d3 also q3 is giving a result when it should be zero can anyone help make this a more polished sheet thank you

 

[Michael M]

Why not simply allow for the zero result. In E3

=if(or(D3="", C3=""),"",D3-C3)

In G3

=IF(OR(C3="",D3=""),"",E3-F3)

 

[HappyChappy]

it's J O Q and T that I'm trying to get right they work fine when c and d are populated but errors when they are empty

 

[Michael M]

the same principle applies to those cells as well, as per the formulas I provided.

 

[HappyChappy]

Why not simply allow for the zero result. In E3

=if(or(D3="", C3=""),"",D3-C3)

In G3

=IF(OR(C3="",D3=""),"",E3-F3)

thank you for the answer