Using Code with Nested formulas

[autigers]

I am attempting to use the following formulas in code on a worsheet change event.
IF(E23="","",IF(G23="","",IF(G23<F23,IF(H23="",G23+1-F23,(G23+1)-(F23+$V$5)),IF(H23="",G23-F23,G23-(F23+$V$5)))))

This formula simply looks at Start times, Finish Times and whether or not a lunch was taken. And then performs the math accordingly based on times and whether or not time is less than midnight etc .. (Time is tricky in excel)

What I would like to do is take the data from sheet "Input" and using the formula above in code, perform the function ...

After this I have other formulas I would like to do the same and then take all data from sheet"Input" and transfer/ Sum again data to multiple sheets ...

 

[autigers]

My formula won't paste correctly into my message ....

 

[autigers]

=IF(E23="","",IF(G23
="","",IF(G23<F23,IF
(H23="",G23+1-F23,
(G23+1)-(F23+$V$5)
),IF(H23="",G23-F23,
G23-(F23+$V$5)))))

 

[autigers]

Heres a sample of the sheet

TimeTrac.xls
	A	B	C	D	E	F	G
1	WMS Logon	OT	Job	Start	Finish	Lunch	Job Hours
2	APPJCL		D	7:45 PM	12:00 AM		4:15
DailyInput