Change the default display time zone for lists
When we upload an excel with another time zone for the date and time column(like Australia time), it will always show the default time zone UTC-8 in the list. I changed the time zone in regional settings (both in SharePoint level and site level), in the tenant level, even in my personal profile. All of them are not working. Besides, when we try to upload the date and time, it only keeps the date with the default time zone and no time kept. I found some date formats in excel are not supported by SharePoint. Please fix the time zone issue, along with the time display issue. Thanks!