Web development, coding & SEO

Counting working time, Outlook & Excel

How to set up MS Outlook and to use MS Excel to count working time.

Output report has to be like this, columns in that order, sorted ascending:

October       Start    Minutes    Subject
2002-10-05    12:34    14         security patches, phpmyadmin install
2002-10-11    23:23    10         mysql limit of connections
total minutes          24

To get a report like this:

1. MS Outlook, Calendar, assign categories to events being counted.
2. Create a new view in Calendar:
   1. View > Current View > Define Views > New, Name of new view: MyTime, Type of view: Table, OK >
   2. Fields..., Start, New Field..., Name: Minutes, Type: Formula, Formula: [duration]*1, OK, Subject, OK >
   3. Group By..., Categories, Ascending, OK >
   4. Sort..., Sort items by: Start, Ascending, OK >
   5. Filter... > More Choices > Categories..., Available categories: check needed, OK >
   6. OK > Close.
3. View > Current View > MyTime
4. select, copy/paste to Excel

2002