Hi,
I need assistance in creating a macro to record the Total Time for each task. Within Start time and End time, analysts might take brake several times(max 5 times - in between a task) which means they can pause the task several times. Hence, I need to record all the Time brake and calculate the total time taken by the analyst.
Please suggest. I am attaching the Macro enabled fine which I have tried so far.
Thanks.
I need assistance in creating a macro to record the Total Time for each task. Within Start time and End time, analysts might take brake several times(max 5 times - in between a task) which means they can pause the task several times. Hence, I need to record all the Time brake and calculate the total time taken by the analyst.
Please suggest. I am attaching the Macro enabled fine which I have tried so far.
Thanks.