Formula help

[kyddrivers]

I am in need of some assistance in tweaking formulas to get the desired results. The situation may be impossible, but I need to ask to satisfy my curiosity.

I will try to include the spreadsheet and describe as best as possible...as always thank you for help in advance!

I have a file that calculates scheduled staffing by interval by entering work days, start of shift, end of shift, lunch start & lunch stop. The intervals (0, 30, 100....2400) are populated based on the start/stop and the lunch start and stop. What I am trying to solve for is shifts that cross over midnight, right now I have to create 1 entry for the time before midnight and a 2nd entry for the time after midnight. I would like to be able to enter the data into 1 line.

The 0 interval (Column U) calculates based on the following formula:
=IF(F15=5,J15,0)

The remaining intervals calculate based on the following formula:
=IF($F15>0,(IF(AND(V$13>=$H15,V$13<$I15),"L",(IF(V$13<$G15,IF(V$13>=$F15,$J15,0),0)))),0)

Let me know if you have any questions.

	Column E	F	G	H	I	J	U	V	W	X	Y	Z	AA	AB	AC
	Work Days	Start	Stop	Lunch Start	Lunch Stop	FTE	0	30	100	130	200	230	300	330	400
Current	SMT==FY	2230	2400			1	0	0	0	0	0	0	0	0	0
	SMT==FY	5	730	230	330	1	1	1	1	1	1	L	L	1	1
Current	SMT==FY	2230	730	230	330	1	0	0	0	0	0	0	0	0	0
What I am looking for	SMT==FY	2230	730	230	330	1	1	1	1	1	1	L	L	1	1

<tbody>
</tbody>