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.
Bookmarks