SharePoint Document Issues

How to Display the SharePoint Created Date in a 12-Hour Format

Rana GarciaRana Garcia Nov 13, 2026 869 views

Question details

The user needs to make the built-in SharePoint Created column display a custom 12-hour date-time format such as 12:11 PM 3/3/2020.

How to Display the SharePoint Created Date in a 12-Hour Format
Product
Microsoft SharePoint
Device & OS
not provided
Scenario
The user manages a SharePoint list or document library and wants the Created column to show a readable 12-hour date-time format instead of the default site or regional format.
Observed behavior
The built-in Created column uses the site or regional date and time settings and does not display the desired 12-hour format by default.
Before you start

Confirm that you have permission to create or modify columns in the target SharePoint list. Open the list or document library where the Created date should be reformatted.

Solution 1Recommended

Create a Calculated Column That Reformats the Created Date

Use this when you want a readable 12-hour date-time column that updates automatically from the built-in Created field.

A calculated column does not change the stored Created value; it creates a separate text column that formats the same timestamp.

Because the result is text, use the original Created column for date filters or sorts.

1
Open the list column settings

In the SharePoint list or document library, select “+ Add Column” and then choose “More...” to open the Create a column panel.

2
Choose the Calculated column type

Enter a name such as “Created 12-Hour”, and under “The type of information in this column is”, select “Calculated (calculation based on other columns)”.

3
Enter the date formatting formula

In the Formula box, enter =TEXT(Created,"h:mm AM/PM m/d/yyyy") and set the data type returned to “Single line of text”.

4
Save and verify the column

Click “OK”, refresh the list view, and confirm the new column shows values similar to “12:11 PM 3/3/2020”.

Create a Calculated Column That Reformats the Created Date
Text column behavior: The calculated column is stored as text, so sorting and filtering follow text rules rather than true date rules.
Free Microsoft Office alternative

Open and Edit SharePoint Files with WPS Office for Free

WPS Office gives you a free, lightweight way to open, view, and edit Word, Excel, and PowerPoint files from SharePoint without changing your SharePoint date settings. It keeps the familiar ribbon interface and supports the same Office formats for smooth migration.

  1. 1. Download the Office file from SharePoint: Download the Word, Excel, or PowerPoint file from the SharePoint document library to your computer.
  2. 2. Open the file in WPS Office: Launch WPS Writer, WPS Spreadsheet, or WPS Presentation according to the file type, then use File > Open to open the downloaded file.
  3. 3. Edit and save the file: Make your changes and save the file. WPS preserves the original Office format such as .docx, .xlsx, or .pptx.
Works with files downloaded from SharePoint, so you can edit them even when SharePoint date formatting is managed by your organization.Full support for .docx, .xlsx, and .pptx formats without file conversion.Familiar ribbon interface reduces the learning curve when switching from Microsoft Office.Lightweight and fast, so you can work with SharePoint downloads without a heavy Microsoft 365 setup.
microsoft office alternative - wps office

Frequently Asked Questions

Can I change the built-in Created column display directly in SharePoint?

You cannot directly format the built-in Created column in the same way you format a custom Date and Time column. Instead, use a calculated column or modern column formatting to change how the value appears.

Does a calculated column change the original Created date?

No. The original Created date remains unchanged. The calculated column only displays a formatted text version of the same timestamp.

Why does my formula show 24-hour time instead of 12-hour time?

Use lowercase “h” for a 12-hour clock and include “AM/PM” in the format string. Uppercase “H” returns 24-hour time in SharePoint text formulas.

Can I sort and filter by the new 12-hour calculated column?

The calculated column is text, so it sorts and filters as text. For true date filtering and sorting, continue to use the original Created column.

Do I need administrator permissions to add a calculated column?

You need the appropriate list permissions, typically “Manage Lists” or “Design” permission, to create or modify columns. Site administrator permission may be required to change regional settings.