Simple Excel time log
I'm a staff engineer at a public university, and one unpleasant administrative thing I have to do is log release time on various projects. The usual quarterly process was something like (mildly exaggerated for humor):
- Get a time log form from the clerical folks.
- "Didn't you start one of these when the project started?" "I'm sure I got the form, but I don't know where it is." "Oh. Here's another one, then."
- Run through modification dates on CAD models, code, whatever.
- Dig through receipts, emails, etc. for other reminders.
- Check DateBK5 for meetings, daily journal entries, etc.
- Scribble down dates, times, durations, and descriptions onto the log form.
- Realize that I'm not likely to get all these entries ordered by date on the first try.
- Erase log entries, get another sheet of paper, and collect every entry from the above primary sources.
- Scan temporary log for earliest date, copy it to the original form, tick-mark it on the temporary log. Repeat.
The attached Excel and OpenOffice sheets are a bit of an improvement on the last few steps. The basic usage would be to enter the project info at the top of the sheet, then fill out dates, starting/ending times, and descriptions into the log table below. The last column will automatically calculate durations, and the sheet header will automatically calculate the date range on your entries. And finally, the sheet header will total up all the durations for the final goal, the answer to "how many hours do you have on this project since (insert date here)?".
One good thing with this setup is that I don't have to worry about the processing phase as much. Just run through each information source and dump dates, times, and tasks. Sort them afterwards with the built-in data sort on any spreadsheet program.
And I get to look slightly more competent. Comments or suggestions welcomed, as is moving this thread somewhere more suitable if needed.
- 7307 reads
