[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
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
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