Late indicator

Hi,

I need help to get the first entry of each day in a record. The first entry will serve as the employees time in. As the employee pass through the door it will be logged in the database.

If the employee's shift is 8:30 AM and his first log is 8:45 AM then he will be tagged as late.

For the first entry of each day, it will log the number of minutes the employee was recorded late in Minutes column and Late? column as Y. The other record will remain blank as it is not needed to monitor the late.

Sheet1 will serve as the record of door logs and Sheet2 will be the employees' schedule for the whole month.

Step :1
Text to Column (Alt+A+E) "Timestamp" from "Space"

2
First "Time Stamp" As Date and next column as day as in sheet.

3
formate output of Text to columns as time and proceed as per sheet.

4.
Prepare a base data in sheet 2 of name combining & date column which represent column number in vlookup formula.

Check the sheet whether it as per your wish.. or need something else.

$hiv

what does Sheet2!6:6 means?

I am trying to use the formula in Sheet3 cell T4 for the summary. If I added an OR to IF statement, the answer is incorrect.

The formula should state like this:

if the result is not in sheet1 then it should lookup the value in sheet2. But, there are instance that the value is not only VL. It may be EL or SL or AWOL or VL 0.5 ... If this is not the value, then the result must be blank.