S
saraskandan
Hi all,
I need to write a macro to find the adherence of the timing from 2 data
provided below. For example, I have a agent supposed to work for "x" no
of hours. In the duration he has to take 3 breaks. The first break for
15 mins, 2nd one for 30 mins and 3rd for 15 mins and timing is slotted
for them in the begining for the day.
They have logged on phone and they have to log out in the given timing,
if he / she does the output should tell me "Adhered" or else "Non
adherence"
Data
Agent availability for the day
Agent 1 08:41 08:43
Agent 1 08:43 08:56
Agent 1 08:56 08:56
Agent 1 08:57 10:42
Agent 1 11:09 12:29
Agent 1 12:29 12:33
Agent 1 12:43 13:16
Agent 1 13:43 14:30
Agent 1 14:42 16:42
Agent 1 16:55 17:36
Agent 1 17:36 18:13
Agents break schedule
Agent 1 10:45 : 11:00 13:00 - 13:30 15:15 - 15:30
can anyone tell me how do this?
I need to write a macro to find the adherence of the timing from 2 data
provided below. For example, I have a agent supposed to work for "x" no
of hours. In the duration he has to take 3 breaks. The first break for
15 mins, 2nd one for 30 mins and 3rd for 15 mins and timing is slotted
for them in the begining for the day.
They have logged on phone and they have to log out in the given timing,
if he / she does the output should tell me "Adhered" or else "Non
adherence"
Data
Agent availability for the day
Agent 1 08:41 08:43
Agent 1 08:43 08:56
Agent 1 08:56 08:56
Agent 1 08:57 10:42
Agent 1 11:09 12:29
Agent 1 12:29 12:33
Agent 1 12:43 13:16
Agent 1 13:43 14:30
Agent 1 14:42 16:42
Agent 1 16:55 17:36
Agent 1 17:36 18:13
Agents break schedule
Agent 1 10:45 : 11:00 13:00 - 13:30 15:15 - 15:30
can anyone tell me how do this?