Macro To Get the elapsed time to complete a particular work.

[dev.sutradhar1987]

Hi,


I want a macro which will record time for completing a particular task in Excel 2007.


The Concept is :-


Suppose Column A has a DropDown with 3 options(In Progress, Hold, Completed) and time will be calculated and shown in Column B

Conditions:

1. If In Progress TIME Starts

2. If Hold TIME Pauses.

3. If Completed TIME Stops and Calculated the Total Time Taken from (In Progress - Completed) and Stores the Final Time In Column B (Time Format HH:MM:SS)


Please could you help me out in this.


Waiting for your Earliest Feedback.

 

[crouchsw]

https://docs.google.com/file/d/0B0di3bZpuEb0emVnbi1oWWVoV3M/edit?usp=sharing


This uses some cells to hold the start time and elapsed time, as well as the data for the list.


When you choose the dropdown list, it runs the macro to do the work.