Converting time problem

[HappyChappy]

Payslip.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	Day	Date	Start Time	Finish Time	Hours Worked	Break	Hours Minus Break	Servicing	Adjust for 39 hours	Basic Hours	Basic Hours	Bonus Hours
2			Days Hours
3	Monday	12/02/2024	07:00	17:00	10.00	0.75	9.25	0.50	0.95	07:48:02	7.80	8.75
19.02.24

Cell Formulas
Range	Formula
E3	E3	=IF(OR(C3="",D3=""),"",D3-C3)*24
F3	F3	=IF(OR(D3="",C3=""),"",1/32)*24
G3	G3	=IF(OR(C3="",D3=""),"",(E3-F3))
H3	H3	=IF(OR(D3="",C3=""),"",1/48*24)
I3	I3	=(IF(OR(C3="",D3=""),"",1/25.28*24))
J3	J3	=IF(OR(C3="",D3=""),"",(E3-F3-H3-I3))/24
K3	K3	=IF(OR(C3="",D3=""),"",J3*24)
L3	L3	=K3+I3

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

Want to do away column k but need column j to display 7.8 not 07:48:02 cant figure it out any help please

 

[FormR]

Hi, column K is just multiplying column J by 24 - if you want column J to return the result directly simply remove the divide by 24 ("/24") from it's formula and format the cell as a number.

 

[HappyChappy]

thank you