Hey all,

Please let me know if it is possible to insert Macros in a formula. That is "if this condition is true, then run macro1 else macro 2".

If the above is not possible, let me know a procedure for this.
1> I need to create a macro which
i) Segregates all the users by their name.
ii) Calculate the time taken for their work.
iii) Create a report for the time frame taken for the task.

Now the problem is
1) when filtered, and sorted,
i) The time when subratcted from the previous task to present task works. But when the first user data is finished, the time shows negative for the second users first task time. How can this be avoided.

Please let me know if there are any other better options than the one I am following to do this task.

Quick help is appreciated.

Thanks,
Pravi