Calender Labels

Resolved · Low Priority · Version 2003

Thu 3 Sep 2009, 13:50 Delegate Gary said...

Gary has attended:
Outlook Advanced course

Calender Labels

I have personalised the label setting so that my various activities can be catergorised (such as per reg teaching, post reg teaching, meetings, professional development etc). I would like to know a way by which I can summarise either monthly and or yearly how much time I have spent on each activity (for example how many hours have I spent on pre reg teaching). I am certain that there must be a way using the office suite but do not know the best way of doing this. Thank you

Tue 8 Sep 2009, 10:31 Trainer Andrew said...

RE: Calender Labels

Hi Gary

Thank you for your question. One way to achieve this may be to switch to your calendar view to events (View > Arrange by > Current view > Events)

This view includes the Duration and Categories fields. Single click on an event and use the keyboard shortcuts CTRL + A and CTRL + C to select all then copy. Switch to Excel and in a blank sheet CTRL + V will paste the event details. You can now filter by category and total duration.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

Mon 14 Sep 2009: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Outlook tip:

Sort messages by multiple headings

It is possible to apply more than one sort to messages using the column headings that appear at the top of your inbox or other folders.

This will allow you to sort, for example, by Sender then by Received date.

Sort firstly by clicking on one column heading (to perform your first sort). As long as you hold down the Shift key in conjunction with clicking on the second column heading you wish to sort by, the messages should not completely rearrange themselves but retain your first sort then apply the second sort to the first sort.

View all Outlook hints and tips