Required excel formulation for attached sheet.

Hello..

I need formula at the sheet 2 so that the attendance can be achieved by denoting "P"- present or "A" . The data can be extracted from sheet 1. The in time has been denoted by date in sheet 1 .Please help. 

The excel sheet has been attached.