formula to tell me when someone is present on work, present late and early departure.

I created a way to tell me when someone is present late or present late but for some reason its perfect with an 8am to 4:45 pm shift but not with the others....any ideas on how I tewak the formula to resolve that..

Formula--=IF(F8="absent","ABSENT",IF(F8="S/L","S/L",IF(F8="VAC","VAC",IF(F8="M/L","M/L",IF(F8="P/V","P/V",IF(F8="B/L","B/L",IF(AND(F8-INDEX($B$8:$B$232,MATCH(F8,$B$8:$B$232))>0,INDEX($C$8:$C$232,MATCH(F8,$B$8:$B$232))-G8>0),"Present Late and Early Departure",IF(F8-INDEX($B$8:$B$232,MATCH(F8,$B$8:$B$232))>0,"Present Late",IF(INDEX($C$8:$C$232,MATCH(F8,$B$8:$B$232))-G8>0,"Early Departure","Present")))))))))..


I need to tweak it somehow to get it to work with an 8hr shift and 10 hrs shift....register new.xlsx

anybody help!!!

omg that is sooooo perfect. Thank you sooo much. my head ache is gone. Thanks alot once more sktneer.