Feedback after comparing time

[Yonggie]

Hi all

If i would like to get the status column automated - i.e. to check the actual time in against the shift time to determine if employee is on time (early), on wrong assigned shift (check) and late, is there a way to do it? I tried =if(or( etc and didnt work...

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Shift Time[/TD]
[TD]Actual Time In[/TD]
[TD]Actual Time Out[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]9:00:00[/TD]
[TD]8:59:00[/TD]
[TD]17:00:00[/TD]
[TD]Early[/TD]
[/TR]
[TR]
[TD]9:00:00[/TD]
[TD]7:15:00[/TD]
[TD]17:00:00[/TD]
[TD]Check[/TD]
[/TR]
[TR]
[TD]9:00:00[/TD]
[TD]9:20:00[/TD]
[TD]17:00:00[/TD]
[TD]Late[/TD]
[/TR]
</tbody>[/TABLE]

 

[VBA Geek]

First you would need to set a criteria to distinguish between (Early, Late) and Check. How many minutes of difference distinguish between Check and the other two? If the employee get in at 9:35, is he late or you need to "Check"?

 

[Yonggie]

Am thinking anything earlier than 30 minutes will warrant a "check", 30 minutes earlier to actual shift start will be "early", and anything more than 9.01 is "late"