Help in VBA

[suhas]

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)

[suhas]

I have also attached the sample screen shot.. PLease can any one help me...

11393

[SamT]

In Cell "S2" put the formula
=IF(B2="","",V2+Y2+AB2+AE2+AH2+AK2+AN2+AQ2+AT2+AW2)
Then Select All cells in column S from S2 to the bottom of the list and press Ctrl+D

[Bob Phillips]

You might find this formula easier to work with/extend

=IF(B2="","",SUMPRODUCT(--(MOD(COLUMN(V2:AW2),3)=1),V2:AW2))

and don't forget to format the result cell as [h]:mm