suhas
03-12-2014, 05:12 PM
Hi All,
Need a help in calculating the same Queues total time using VBA.
Ex: I have 10 queues need to calculate the total time spend on each queue.
Ticket number: 1001 is sent to queue1 and later sent to queue2 followed by Queue3, Queue4 and later came back to Queue 1: Now I need to know the sum of Queue1,Queue2,Queue3.
Challenges: All these queues are in coloums, ticket numbers are in row. After each queue there are 2 other coloums( Date when the ticket was assigned to queue) and total hours spent on that queue(days:hh:mm:ss format)
Need a help in calculating the same Queues total time using VBA.
Ex: I have 10 queues need to calculate the total time spend on each queue.
Ticket number: 1001 is sent to queue1 and later sent to queue2 followed by Queue3, Queue4 and later came back to Queue 1: Now I need to know the sum of Queue1,Queue2,Queue3.
Challenges: All these queues are in coloums, ticket numbers are in row. After each queue there are 2 other coloums( Date when the ticket was assigned to queue) and total hours spent on that queue(days:hh:mm:ss format)