Hi,
I want to generate report that will compute Time Difference with special conditions:
Schedule of 7:00AM - 4:00PM (code 1) - can be late for up to 7:30 and out of 4:30 anything above 7:30 is considered late even if out is 4:30PM onwards.
Schedule of 7:00AM - 4:00PM (code 2) - can be late for up to 8:30 and out of 5:30 anything above 8:30 is considered late even if out is 5:30PM onwards.
I have attached sample sheet. T
Thanks in advance.
Bookmarks