• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Activity Tracker VBA with Start Stop and Reset Buttons

ajayxlnc2

New Member
Hi I need a snapshot of a Time tracker for each task.
I Want the following Tabs to be
Name : Free Text
Team Name : Sample1, Sample2, Sample3, Sample4, Sample5, Sample6, Sample7, Sample8 (Drop Down List)
Task :
Sub Task : Core Task: Free Text
Diverted : Sample1, Sample2, Sample3, Sample4, Sample5, Sample6, Sample7, Sample8 (Drop Down List)
Status : Sample1, Sample2, Sample3, Sample4, Sample5, Sample6 (Drop Down List)
Reason For Sample3 : Sample1, Sample2, Sample3, Sample4, Sample5 (Drop Down List)
Time : Time taken for that particular task should be displayed after clicking the stop button. (h:mm)

Start Stop and Reset Button

And when i need to know who all has taken how much time to complete the task by a report means if i select the select can i be able to get the time taken for each task.
Please let me know whether this can be done
 
Hi,

There is a little bit modification to the above

I have uploaded the sample file and requirement.

I am looking for a snapshot which can be shown in Snapshot Worksheet which shows the details which i want.

When i click on start, the timer should display the start time and when we click on Stop it should display the end time and Time Taken for that task also should be calculated. If possible, when i click on pause the timer should stop and when we start again it should start from where it paused.
Reset button to reset all the form data (Clear all the values) so that i can enter select new task.

When Stop button is clicked i want the form data to be copied to the other Sheet "report".

Is that possible ?
 

Attachments

  • Sample.xlsx
    12.2 KB · Views: 65
Back
Top