F FUNCTION

Closed
YAZAN - Dec 31, 2009 at 03:35 AM
yazan_h158 Posts 1 Registration date Wednesday December 30, 2009 Status Member Last seen December 31, 2009 - Dec 31, 2009 at 03:55 AM
Hello,
here is the situation

Data is

Time In 8:30 am
Time out 05:00 pm

Now i want the If Formula to function , that if the employee come late to work after in time (8:30 am) and leave work earlier than out time (5:00 pm) happens the value turns to "Fails".

in other words, I am working on a time sheet, and i need to verify when workers r coming late or leaving earlier than the allowed time, so what i need is when i enter the time in A1 it shows in B1 that he's "late" otherwise "Ok"

any time like before 8:30am and after 05:00pm should be OK am and after 4:30 pm should be false and data between 9-4:30 should be true.

Waiting for expert opinion.
Related:

1 response

yazan_h158 Posts 1 Registration date Wednesday December 30, 2009 Status Member Last seen December 31, 2009
Dec 31, 2009 at 03:55 AM
SORRY THERE WAS A MISTAKE IN THE LAST PART

any time like before 8:30am and after 05:00pm should be OK

Waiting for expert opinion.
0