Quote:
Originally Posted by Mazzaropi
-------------------------------------------------------------------------
Dear SalienteAnimal, Good Morning.
I couldn't understanding well your explanation.
Could you modify the original worksheet I sent you, puting one example that what you want now in a clear way?
I believe that this will easier the understanding and solution process to your necessity.
You can use the same procedure that I used to save and share the worksheet.( www.4shared.com).
I waiting your answer. |
Good Morning Mazzaropi,
Unfortunately I am unable to access the link that you provided. Could I possibly e-mail the file? Alternatively I will try and explain it again using the criteria fields:
Criteria 1
Between 06:00:00 and 06:30:00
Agent has a break of 00:33:00
Criteria 2
08:00:00 and 08:30:00
Agent has a break of 01:03:00
Criteria 3
09:00:00
Agent has a break of 01:03:00
Should the evaluated value fall between one of the specified value it needs to return a value of "Yes". If however the value falls outside the three mentioned criteria it needs to return a value of "No". Once the first evaluation is complete it then needs to check the break times. If the agent exceeds the allocated break time all other criteria should fail and it should be marked as a "No".
Thanks Again for your assistance, I really do appreciate it.