I’ve made my first iteration of a program to record my tasks (genesis here).
Create a bunch of general work-oriented categories. Then, when the timer goes off, have XL display a Userform that lets you allocate the last hour by percent in each category. Even if you’re away from your desk when the timer goes off, the code can determine the time since the last entry and adjust.
Good idea, but I have two problems with it: First, it locks me into categories – or at least I can’t change them on the fly. That’s probably not as big of a deal as I think. In fact it might be better than having me go from too specific to too general in the category department. So maybe I don’t have a problem with it.
Second, I want to record the actual tasks. I want to answer the question, “I spent 4.2 hours on IT? What the hell did I do?”
Instead of recording tasks every half hour, I’ll record them whenever I switch tasks. Sometimes that will be five minutes and sometimes two hours. Here’s basically how it’s going to work:
When the workbook is loaded it checks to see if there are any entries. If there aren’t any entries or the last entry if not from today, a new entry is created that sets the time the day is started. Then the hotkey Ctrl+Shift+T is assigned to open the form. Finally OnTime is used to open the form in 30 minutes.
If I open the form and create an entry, the timer restarts. The timer serves as a reminder in case I forgot I’m supposed to be recording stuff. For longer tasks, I’ll just dismiss the form if I don’t have an entry to make.
The three buttons next to the date picker decrement the dtp by 10 minutes, increment the dtp by 10 minutes, and set the dtp equal to the current time, respectively. If I come back to my office and the form is showing, I can quickly change the time to now and record the task.
The Category combobox is seeded. That is, I came up with a number of categories that I wanted to include right from the start. But I can still make up whatever category I want. The combobox is populated by the seed categories plus whatever other categories exist in the database. I suppose this will get slower as the database gets bigger.
The listbox on the bottom shows the last eight entries, just for some perspective.
When saved, the time, category, and task are recorded onto the workbook. Right now the workbook is simply hidden. I’ll either copy it into XLSTART or make it an add-in.
You can download TaskIt.xls.zip
Update: You can download TaskItv2.xls.zip
Update: You can download TaskItv3.xls.zip