sheet name changed, try this (confirmed with Ctrl+Shift+Enter)

=IF(AND(TIMEVALUE(LP!E$9&":"&TEXT((LP!E$9-INT(LP!E$9))*60,"00 ")&LP!F$9)<=$A29,TIMEVALUE(INT(LP!G$9)&":"&TEXT((LP!G$9-INT(LP!G$9))*60,"00 ")&LP!H$9)+IF(AND(LP!F34="PM",LP!H34="AM"),0.5,0)>=A29),1,0)