SharePoint Document Issues

How to Display SharePoint List Times in Different Local Time Zones

Maira Mehtab Sep 22, 2026 868 views

Question details

Users need to display events in a SharePoint campaign calendar in their own local time zones, despite the site being configured to use UTC.

Product: SharePoint
Device & OS: not provided
Scenario: A distributed team is viewing a shared SharePoint campaign calendar and needs to see event times converted accurately from UTC to their specific geographic regions (e.g., U.S. Eastern to Central European Time).
Observed behavior: SharePoint list views default to the regional settings of the site (UTC) and do not automatically convert list item times for individual users viewing the calendar.

Before you start

Ensure you have Site Owner or Designer permissions on the SharePoint site to modify list settings, create new calculated columns, or integrate Microsoft Power Apps.

Solution 1Recommended

Use Power Apps to Customize the List Display

By integrating Power Apps, you can create a custom view that detects a user's local time zone and dynamically adjusts the displayed SharePoint list times.

Since SharePoint list views do not natively support per-user time zone conversions, Power Apps offers the most flexible workaround. This method allows you to build a custom interface that reads the UTC data and formats it according to the local device time of the person viewing it.

Integrate Power Apps

Navigate to your SharePoint list. In the top command bar, click on 'Integrate', select 'Power Apps', and then choose 'Customize forms' or create a new application.

Add a Gallery Control

In the Power Apps Studio, insert a Gallery control and connect it to your SharePoint list data source to display the calendar events.

Adjust the Date/Time Formula

Select the label displaying the event time. Modify its Text property using Power Apps functions like DateAdd and TimeZoneOffset to convert the UTC value into the local time of the user.

Publish the App

Save your changes and publish the app back to SharePoint. Users can now view the list through this custom app to see times adjusted to their local regions.

Microsoft Feedback: Because native per-user time zone conversion is a highly requested feature, consider submitting this requirement to the Microsoft Feedback Portal.

Solution 2

Create Custom Calculated Columns for Specific Regions

If you only need to support a few specific time zones (like EST or CET), you can create calculated columns that display the mathematically adjusted times next to the default UTC time.

Free Microsoft Office alternative

Simplify Your Shared Calendars and Documents with WPS Office

If SharePoint's strict regional settings and complex workarounds are slowing down your global team's workflow, consider managing your schedules and spreadsheets with WPS Office. It provides a lightweight, flexible environment for cross-regional collaboration without the steep learning curve.

1. Download and Install: Visit the official WPS website to download and install WPS Office for free on your preferred device.
2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Microsoft Excel calendar or schedule files directly.
3. Collaborate Globally: Use WPS Cloud to share document links with your international team, ensuring everyone is on the same page effortlessly.

100% compatible with Microsoft Excel, Word, and PowerPoint formats.Easily manage global schedules and time-sensitive spreadsheets without complex server-level timezone configurations.Free to use with a familiar, user-friendly interface that requires zero training.Cross-platform support ensures seamless collaboration across Windows, Mac, Linux, iOS, and Android.

microsoft office alternative - wps office

Frequently Asked Questions

Can individual users change their own time zone settings in SharePoint?

Yes, users can update their personal language and region settings within their Microsoft 365 profile. However, SharePoint list views and shared calendars often still default to the site-level regional settings established by the administrator, ignoring personal preferences for those specific displays.

Why does my SharePoint calendar show UTC instead of my local time?

SharePoint lists and calendars rely on the regional settings configured at the site level. If the site administrator set the default regional time zone to UTC, all events will display in UTC for all users natively.

How do I change the default regional settings for an entire SharePoint site?

If you are a site administrator, click the gear icon and go to 'Site Information' > 'View all site settings'. Under 'Site Administration', click 'Regional settings', where you can change the default Time Zone for the entire site.

Will calculated columns automatically update for Daylight Saving Time (DST)?

No. Calculated columns in SharePoint rely on static mathematical formulas (e.g., adding a fixed number of hours). When Daylight Saving Time begins or ends, you will need to manually update the formula to reflect the new time difference.

Document & File Issues