VBA to calculate half day/ full day as per time sheet

Hi Friends,

I need your help in the attached time sheet to calculate whether the employee is entitled for half day or full day salary. The rule is simple: Either he logs in after 1200 hrs or logs after 2100 hours or both, he is marked as half day, else full day.

I would like conditional formatting for half day employee cells, name filled with red, and also copied to a new sheet.

Attached is workbook for reference.