Looking for assistance in calculating how many hours late.
<tbody>
</tbody>
In C, I would like the remarks L1 if late between 8:16 AM to 9:00AM, L2 if 9:01 AM to 10:00AM, L3 if 10:01 AM to 11AM and so on.
I would like any help so each time I will make my DTR report, it will automatically place the remarks (L1 or L or L3....) if the database of time log are pasted on my worksheet.
It will at least shorten my time doing the daily time record of 50 employees.
Your help would be greatly appreciated.
Thank you very much
A | B | C |
IN | OUT | LATE |
8:16 AM | 5:00 AM | L1 |
<tbody>
</tbody>
In C, I would like the remarks L1 if late between 8:16 AM to 9:00AM, L2 if 9:01 AM to 10:00AM, L3 if 10:01 AM to 11AM and so on.
I would like any help so each time I will make my DTR report, it will automatically place the remarks (L1 or L or L3....) if the database of time log are pasted on my worksheet.
It will at least shorten my time doing the daily time record of 50 employees.
Your help would be greatly appreciated.
Thank you very much