[UPDATE: This is no longer available for distribution–sorry. -AG 7.14.05]
Just developed this little tool - “TimeSheet” - for a friend of mine. It loops through your calendar for a selected date range and outputs the total hours by category (or subject, company, location, whatever–I could change it for whatever you need).
If you put a client’s or project’s name in the “Categories” field, this would be a super easy way to track your work. It creates a printable report using a Post Item, which could be saved to a ‘clients’ or ‘projects’ folder as needed.
If you’d like me to customize this tool for you, sign in and leave a comment - I’ll keep your comment hidden and contact you via email. (There would be a nominal fee, depending on how much customization you’d need.)
gmail.com
2 responses so far ↓
1 Tony // Jun 21, 2006 at 2:52 am
Hi, I am interested in using this application you’ve developed. Please can you tell me if it could be used to track hours I spend on jobs for clients?
How do I get it?
Thanks,
Tony
2 Aron // Jun 28, 2006 at 9:21 pm
Hi Tony,
I’m sorry, but this little tool is no longer available for distribution. And it really didn’t work very well anyway, so it’s probably for the better. Outlook’s Calendar is a really easy way to go - perhaps use some custom color-labeling for each client, then put your activities in the body of the appointmentitem. Drop this code into a module and add a button on your toolbar to run it:
Sub AddHours()Dim i As AppointmentItem
Dim h As Single
'totals the hours for selected appointmentItems
h = 0
For Each i In ActiveExplorer.Selection
h = h + DateDiff("n", i.Start, i.End)
Next i
MsgBox Format(h / 60, "0.0") & " Hours", vbInformation, "Total Hours"
End Sub
When you’re ready to tally up your hours for a given client, just select all the appointment items in your calendar and click the button - a message box will pop up with the total hours. Simple little hack, but it’s what I use since each client does billing differently.
Any trouble, let me know.
AG
Leave a Comment