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