Hello,

I am building a schedule program that will graph out and employees schedule based on start/end/2 breaks and a lunch. I have been successful so far IF the shift in its entirety is in the single day. The problem I am in need of assistance with is a split shift or a shift that goes up to 00:00. The grid starts @ 00:00 and is plotted out to 23:45. The formula used will compare start times to times on the grid and compare break times and lunch times and mark them with "X" for working, "B" for break, and "L" for lunches. The formula however DOES not like a end time that is less then the start time. Is there another variable that is needed for this function to symbolize the day or the shift number.

here is an example of the forumula:

=IF($B3="","",IF(OR(AND($D3<>"",N$1=$D3),AND($H3<>"",N$1=$H3)),"B",IF(AND(N$1>=$E3,N$1<$G3),"L",IF(OR(N$1<$C3,N$1>=$I3),"","X"))))

B3 is the name of the employee
N1 and on is the time entered in in 15 min blocks
column D and H are breaks
column E is the lunch
Column I is end shift

Any help would be appreciated, and thanks in advance