• Report Hours by Category and Duration (2002)

    Home » Forums » AskWoody support » Productivity software by function » MS Outlook and email programs » Report Hours by Category and Duration (2002)

    Author
    Topic
    #364022

    I want to create a daily report of my time by categories. I log my work with appointments that I assign categories to. (The categories are the number assigned to the project for billing.) I want to automate creating a report that will sum the hours I logged for each category used that day. Ideally, it would create a table for each category that lists the each appointment’s subject, start time, end time, duration, and notes, with total of time spent for that category and a sum of the time worked that day. Outlook has the data! but how do I extract it for the report? Can this be done with views?? Would I need to use VBA?

    I think this would be easy if I were using Access to log all my time and I suppose that may be my solution. However, I don’t want to run Outlook, Access, and the several other programs I use all day at the same time. Can Access pull data out of an Outlook database? brickwall

    Reply To: Report Hours by Category and Duration (2002)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: