Snasui Excel Forum

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,

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.

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,

sna wrote: Fri Sep 25, 2020 5:35 am 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.

Ok.thank you very much