Here's the what I'm trying to figure out: TS policy states that you are compliant if you enter your time in the TS system for the current day on the next day before 10 am
I have the hours date in column A; Actual Hours in Column B; Date the hours were entered in Column C; Time the hours were entered in Column D; Result 1 in Column E
For the first result - I want to know if the person filled in the time sheet daily. - this one easy..
'=IF(A1=C1,"Daily Entry","No Entry").
The next result I want is to see if the TS entry was compliant with company Policy - which is you must enter Today's time by 10 am tomorrow...
=IF(AND(A1=C1,E1="Daily Entry"),"Compliant",IF(OR(A1=C1,AND(A1+1=C1,D1<"10:00:00 AM")),"Compliant within Policy","Non-Compliant"))... this formula is not giving the correct result .. is will say compliant even if the time the hours were entered are after 10 am...
Any help is appreciated.
Thanks, UMD
Bookmarks