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?