sharing task

[sna]

Hi Dear
Coming back.
I need your help how to calculate duration in minutes between column T and Column S and show result in Column AA.
Once more I need your help how to allocate work load for people in column AD.
I have data 56 transactions for 4 people.I want to allocate those transactions into 14 transactions per each person.the output as in sheet RESULT .
I do this manually every day
Is it possible to do this with Macro????


Best Regards,

[snasui]

Try this,

Cel AA6

=SUBSTITUTE(T6,"|","")-SUBSTITUTE(S6,"|","")

Enter and copy down > Set number format to h:mm:ss

I can't understand your report and not found macro in your file that related with this task.

[sna]

I don't know how to create macro for this.I need to generate report to allocate workload for 4 people as listed in Column AD.i mean there're 56 transactions and 4 people so 56/4=14.so each has 14 transactions to complete.if 73 transactions so 73/4=18. The purpose I need to assign transactions to 4 people equally.the output should be like in RESULT Sheet.
Is it possible to do with macro?

Best Regards,

[snasui]

I don't know how to create macro for this.

The one rule of this forum is you must write code with yourself. If it has any problem, you can ask here.

[sna]

Ok.thank you very much