I use an Excel 2007 table to keep a log of daily activities. (See the
simplified example below).

I want to construct for my own use a simple reporting system that will
quickly display the answers to such queries as this:

Show me the total hours I spent on each activity on 2009-11-13.
Show me how many hours I spent on running last week (or last month).
Show me a week-by-week breakdown since the beginning of the year of my
totals for writing and music.

How can I do this with minimum fuss? I don't expect anyone to walk me
through it step by step, but it would be helpful to know what tools will be
useful: PivotTables? Macros? I don't want to have to enter formulas
repeatedly. Ideally I'd like to be able to make choices from drop-down lists
or menus.

I'd welcome any guidance on the basic approach, as well as web addresses for
any useful demos or existing samples I can use as models.

Thanks.

David

THE DATA SOURCE:

DATE TASK HOURS

2009-11-13 music 1.5
2009-11-13 running 1.0
2009-11-13 music 0.7
2009-11-13 work 5.2
2009-11-13 work 2.0
2009-11-13 writing 2.5
2009-11-14 work 3.2
2009-11-14 writing 2.3
2009-11-14 music 1.6
2009-11-15 running 1.2
2009-11-15 work 4.5
2009-11-15 music 2.0
2009-11-15 music 0.5
2009-11-15 writing 2.2