Reoccuring appointment issues when exporting Calendar to Excel

dip324

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Hello,

At work we use our outlook calendars to track and analyze time. Several people (but not all) are having two issues with the export:

1. We have a reoccuring event called Work Hours which obviously displays how many hours people worked on that day. When the calendar is exported, there are extra Work Hours events for the weekend in Excel that are not indicated in the calendar (no one works weekends).

2. If the time of a reoccuring event is modified, that event will not export to excel.

Thank you for your help,

Sincerely,

Deanne
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Exceptions should export - unless the exception was erased. (Exceptions are easy reset.)

Is there any thing about the weekend events that export that might give us a clue? Is there something similar in the ones that include weekends and ones that don't?
 

dip324

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
The only pattern I can find is that it copies the Work Hours from Mon-Fri and carries it over to the weekend. On the reoccuring section of the event, Sat and Sun are not checked. No one has work hours for the weekend so they are never on there. I checked the 'Work Hours' Option in Outlook under File--> Options --> Work Time and only the work days are selected.

Deanne
 

dip324

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
The exceptions also are visible on the calendar (not erased), it's just they are not there when it's exported.
 
Top