Attendance tracker IF functions

Hello

I badly needed help in doing my template.

I was trying to create an attendance tracker where i can identify whether a person is "early", "on time" or "early" to be shown the in Status Column.

I tried using some formula but it doesn't seem to be right.


time.png


I have attached the link to file below

https://drive.google.com/open?id=1HV...HwYpvkUz3GsN7U