Macro To Record Time Keeping

**LstarS** · 12-16-2009, 10:44 AM

Hi all,

I am currently involved in running an exercise to monitor the time spent on different activities. For example the activities could be :

Incoming phone calls
Outbound calls
Email queries
Training
Meetings

I have done this exercise before very manually by asking people to input time spent on a spreadsheet. What I am now looking at is having a button for each activity on a spreadsheet which when clicked would start a stopwatch to record the time and either when clicked again would stop or have two buttons for each activity, start and stop.

Is this possible and would i be able to view the results in a tabular format.

**davegugg** · 12-16-2009, 03:08 PM

Why don't you set up your table that will contain the results and post the workbook, then I can add button or perhaps a form to record the time into that table. I'd suggest a start, stop, and total time for each activity.

**royUK** · 12-16-2009, 03:52 PM

Try this. You need to add buttons & columns for the other categories

**Ted Soper** · 12-03-2013, 08:04 PM

New member, so please excuse my lack of protocol and knowledge! I like the timekeeping log, but if you set up multiple activities to track, how do you keep someone from clicking on another activity button before stopping the previous activity? In other words, each activity has to be mutually exclusive...they can't be doing more than one activity at the same time (in my instance). Thanks for your help!

**arlu1201** · 12-04-2013, 02:49 AM

Ted Soper,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.