Forum Discussion

Steven van der Bles's avatar
Steven van der Bles
Copper Contributor
Nov 10, 2020

Time zone settings in Microsoft sharepoint lists

Hi  In my SharePoint site i work with several lists where I store basic data were always some date and time columns are used. I checked al the time settings after reading a lot of topics about this ...
admin
Lists
microsoft lists
SharePoint Online
Usage
HazwaniIsmail's avatar
HazwaniIsmail
Copper Contributor
May 18, 2023
What i always had to do is convert the Created times into my specific timezone in Excel or Power BI.. annoying yes... Unless there is already a fix by now which I'm not yet aware of.
SRMcMahon's avatar
SRMcMahon
Copper Contributor
Oct 29, 2023

I am having the same problem. I am trying to learn how to convert an excel sheet to list to calendar view. The excel file I will eventually be using (which is updated daily) gave me problems when I tried to create a list from it so I decided to start with a very simple excel file to see if I could actually perform this process. That worked fine, except the times in the excel file (I'm in US central) change to US Pacific time when the list is created. Sharepoint regional time is set to US Central. Excel has no date/time format which includes time zone. I'm not worried about people creating events, ultimately I will be copying the excel file from email attachment daily (automating that is a distant dream right now). Not using Power BI or automated workflows or anything. 

Resources