Date and time on miscrosoft lists

Aled Treharne 0 Reputation points
2026-09-08T17:15:42.5733333+00:00

I have created a Microsoft lists list. I have imported a calendar from Excel. It has converted all my dates and time to US format and 12 hour clock. I need UK time and 24 hour clock.

I have been told it has something to do with my Microsoft account. My Microsoft account is a school account I use as a teacher and when you go into settings is set to UK time and UK location,

Microsoft 365 and Office | Office Online Server
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Kai-L 18,970 Reputation points Microsoft External Staff Moderator
    2026-09-08T17:40:55.0733333+00:00

    Dear Aled,

    Your Microsoft account settings are only part of this. A Microsoft List is stored on a SharePoint site, and the site’s regional settings control how dates and times are normally displayed. Ask the site owner or school IT administrator to check:

    Open the SharePoint site containing the list.

    Select Settings > Site information > View all site settings.

    Under Site Administration, select Regional settings.

    Set:

    • Locale: English (United Kingdom)
    • Time zone: the appropriate UK time zone
    • Time format: 24 Hour

    Select OK, then reopen the list. 

    If you don't know who your IT administrator is, please refer to this article: How do I find my Microsoft 365 admin? - Microsoft Support 

    Also confirm the browser’s preferred language is English (United Kingdom), because the modern Lists interface may use browser locale information in some date-entry screens.

    I hope this information helps clarify the situation and provides you with a clear path forward. Should you have any further questions or need additional assistance, please don't hesitate to reach out. I'm always happy to help. Have a wonderful day! 

    If the answer is helpful, please click "Yes" and kindly upvote it. If you have extra questions about this answer, please click "Comment".  

    Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.  

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.