Time and date issue when importing SharePoint calendar

%3CLINGO-SUB%20id%3D%22lingo-sub-1083670%22%20slang%3D%22en-US%22%3ETime%20and%20date%20issue%20when%20importing%20SharePoint%20calendar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1083670%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20company%20uses%20a%20SharePoint%2F%20shared%20calendar%20for%20bookings%20of%20rooms%20and%20spaces.%20At%20the%20end%20of%20the%20month%2C%20we%20import%20the%20calendar%20and%20analyze%20the%20data.%20In%20doing%20so%20I%20noticed%20that%20the%20invisible%20date%2C%20which%20is%20attached%20to%20each%20time%20value%20was%20set%20to%20the%20year%201900.%20This%20creates%20a%20problem%20with%20timelines%20etc.%20Is%20there%20any%20way%20that%20I%20can%20avoid%20this%20issue%20in%20future%20or%20fix%20it%20on%20the%20current%20spreadsheets%20%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETHANKS!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1083670%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECalendar%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

My company uses a SharePoint/ shared calendar for bookings of rooms and spaces. At the end of the month, we import the calendar and analyze the data. In doing so I noticed that the invisible date, which is attached to each time value was set to the year 1900. This creates a problem with timelines etc. Is there any way that I can avoid this issue in future or fix it on the current spreadsheets ? 

 

THANKS! 

0 Replies