Hi,
I have 2 IF statement I have been using for years and worked fine. I'm now dealing with an operation that works 24 hours and I am running into problems. If the start time is before midnight and the end time is after midnight the formulas do not work properly. The first formula deals with overlapping time (the operator must finish one order before he/she can start the next). The second one helps the person filling out the sheet if they accidently put an end time which is before the start time (example start time 08:00 end time 07:50).

D=Employee
J=Start Time
K=End Time

Overlapping Time
=IF(J3="","",IF(AND(D2=D3,K2>J3),TODAY()+J3-(Today()-1=K2)>6/24))

Start B4 End
=IF(J2<K2,TRUE,IF(J2="","",TODAY()+K2-(TODAY()-1+J2)<6/24))

Any help would be appreciated.
Thanks,
Em