Export Vacation & Personal appointments to Excel
Sometimes it's useful to have a filtered spreadsheet of personal time for employees for payroll or vacation tracking purposes.
- Select Calendar::View Calendar. Click the Options... button
- Change these settings:
- Activity Types = Appointment
- Display type = Day by Display Field
Click Select Fields... Delete unnecessary fields and select Activity::Assigned To, Appointment::Appointment Category & Activity::Duration. Click OK
Click the Add Filter... button. Select Appointment Field and select the desired categories (your categories may differ). OK
Select the results with mouse and/or shift key. Copy & paste into Excel.