Time tracker with Timeline Functionality

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.