Time tracker with Timeline Functionality

**markjapeth** · 07-09-2013, 06:26 AM

Hello experts,

I'd like to create a Time Tracking tool wherein i can use different push buttons (e.g. Production, break, Meeting, downtime, and end buttons) to mark how much Production time, break, meeting, and downtime there is on a given transaction.

I wish to use VBA tools and input and extract data in MS Excel 2010.

For example:

When I click Production at 11:00, it will start tracking at 11:00; when I suddenly need to be on a meeting so I clicked on "Meeting" at 11:15.
I finished the meeting at 11:45, and clicked Production. I finished Production by 12:00 and hit End.

So in this tracker it should generate a Production time of 30 minutes and Meeting time of 30 minutes as well.

Any advise?

**hamjam** · 07-11-2013, 05:43 AM

Hello markjapeth
You say you want different buttons for a transaction but then provide an example of someone tracking their activity during a 1 hour interval.

Are you looking to track what type of activity is being done at any time, i.e. you are doing some type of activity until you push the button and another activity starts, the timer just carries on until the next time a button is pushed? So at the end of the day, the data will have a bunch of times and type of activities

Or are you looking for a timer for each of the type of activities and these are added to, when the activity is selected.

Is your time interval 15 minutes or do you just round the totals to closest 15 minute for reporting?

Regards

**markjapeth** · 07-15-2013, 02:32 AM

Hi hamjam -

I would like to have toggle buttons that will reflect a certain activity and time stamp it accordingly; wherein if the first toggle button (e.g. production) is clicked it will time stamp and indicate the work status, if the second toggle button (e.g. meeting) is clicked, it will time stamp meeting and stop tracking production, if clicked on production button again, it will time stamp and track production time again stopping the second toggle button (meeting) to track time. i wish to have this tracker open time, not limited to 15 minutes or 1 hour tracking.

I have created a set of formulae to calculate for the time stamps for each work stata however i am limited by the VB scripts from the toggle buttons that i want to incorporate.

Moving forward, i wish also to have the data plugged into a different sheet everytime a workshift is completed.

**hamjam** · 07-15-2013, 01:50 PM

Hello there
I have written a basic open ended timer below that I connected to 4 buttons, a start and end plus the production and meeting. This can obviously be expanded to a bunch other states as well, as you require.
This creates a new record and you will have to use formula to calculate the elapsed time between different activities, making the assumption that while the clock is running, the last activity is continuing.

Please Login or Register  to view this content.

Regards

**markjapeth** · 07-16-2013, 05:57 AM

hamjam -

I'm just wowed how fast you did this. Big time thanks for sharing your knowledge, truly appreciate your help.

Regards,

markjapeth

**Jjs210** · 01-19-2015, 07:57 AM

Hi

Is it possible to post the file to view this, I am trying to create the same and I am going mad.

Thank you

**hamjam** · 01-20-2015, 04:38 AM

Hello
Lucky for you, I did manage to find this file, this was done about 2 years ago.

Regards

**Jjs210** · 01-21-2015, 12:29 PM

Thank you so so much this is an amazing piece of work. This has helped me lots!

**james.premkumar** · 02-06-2015, 04:44 AM

Hi Hamjam, i would like to work on a similar tracker for the entire production floor to tracker as to how many breaks an agent has taken for the day and the duration of break. is it possible by using only excel formulas to calculate the same?