Help needed to write a macro

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?
 
Top