Hi,
I want to be more productive at work, so I want to track my total productive hours, the total amount of time I took taking breaks, and my total time in the office.
Is there a way to come into the office and "start work" to track my time in the office, and then also have a timer going for productive working hours and total break time? I want to start a clock when I arrive at the office, hit a button when I start productively working, and then hit a button when I take a break. When I hit the button to start a break, it would automatically stop my "working hours" and start my "break time". Then when I got back from my break, I would hit a button to stop my break which would then automatically start tracking my productive hours.
I created something that I liked in Excel using VBA and formulas, but it got too complicated and was causing excel to run way too slow. Attached are some screenshots. When I start the day by hitting "start work", it automatically creates a timestamp with the date, action, and start time. Then when I take my first break for the day, I hit "start break" and it creates another timestamp with the date, action, start time, and the total minutes between my last time stamp (this would be my total time worked for the day). Then when I would get back from my break to my computer, I would hit "stop break". This would create another timestamp with the date, action, start time, and time between my last timestamp (my total break time). Then I would have totals at the top that would consistently add everything up. That way I can see my total productive hours for the day so far, my total time take for breaks, and my total time in office. I like tracking this because I want to get at least 8 productive working ours in a day. I want to take breaks throughout the day, so I want to keep a running total of that as well. Then I want to see how long I was in the office before I hit my 8 hours of productive work as well as how much time I took for breaks throughout the day.
At the end of the day, I would hit "stop work" which would automatically take my summary of the day and document it on the a separate time. This way I can keep track of my hours for the week. How do I replicate this process in the desktop app?
Thanks!
Josh !


