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.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]Column E[/TD]
[TD] F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]U[/TD]
[TD]V[/TD]
[TD]W[/TD]
[TD]X[/TD]
[TD]Y[/TD]
[TD]Z[/TD]
[TD]AA[/TD]
[TD]AB[/TD]
[TD]AC[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Work Days[/TD]
[TD]Start[/TD]
[TD]Stop[/TD]
[TD]Lunch Start[/TD]
[TD]Lunch Stop[/TD]
[TD]FTE[/TD]
[TD]0[/TD]
[TD]30[/TD]
[TD]100[/TD]
[TD]130[/TD]
[TD]200[/TD]
[TD]230[/TD]
[TD]300[/TD]
[TD]330[/TD]
[TD]400[/TD]
[/TR]
[TR]
[TD]Current[/TD]
[TD]SMT==FY[/TD]
[TD]2230[/TD]
[TD]2400[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]SMT==FY[/TD]
[TD]5[/TD]
[TD]730[/TD]
[TD]230[/TD]
[TD]330[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]L[/TD]
[TD]L[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Current[/TD]
[TD]SMT==FY[/TD]
[TD]2230[/TD]
[TD]730[/TD]
[TD]230[/TD]
[TD]330[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]What I am looking for[/TD]
[TD]SMT==FY[/TD]
[TD]2230[/TD]
[TD]730[/TD]
[TD]230[/TD]
[TD]330[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]L[/TD]
[TD]L[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]