Too Many IF's!

[JennyLeah331]

In a nutshell, I'm running a schedule adherence report, finding out people's login and logout times, comparing them to their scheduled in and out times, and if they're off, the cells are blank, if they're not showing up on a day they're scheduled, I need it to return 0, and if they're arriving late or leaving early, I need it to return a 1. What I've got works. But I'm pushing the limit of the number of IF's I can use, which is a pet peeve. So once again, I'm asking you Excel gurus to help a girl out and streamline where possible:

=IF(('in | out times'!BE25="")*AND('in | out times'!BF25=""),(IF((schedule!D65="")*AND(schedule!E65=""),"",0)),(IF(('in | out times'!BE25<=(schedule!D65+0.002766))*AND('in | out times'!BF25>=(schedule!E65-0.002766)),2,(IF('in | out times'!BE25>(schedule!D65+0.002766),1,(IF('in | out times'!BF25<(schedule!E65-0.002766),1,0)))))))

Thanks so much!

 

[AlphaFrog]

Try something like this. Substitute the words for cell references.

=IF(ShiftStart="","",
       IF(LogIn="",0,
            IF(OR(LogIn > ShiftStart,LogOut < ShiftEnd),1,
                    "They worked their shift")))

Wasn't sure what you want returned if they worked their shift on time.