How to Show Date and Time in the Created Column of a SharePoint List

When you create a new SharePoint list, a “Created” column is automatically generated. This column stores the date and time when each item was created/added to the list. However, by default, SharePoint displays the date, leaving out the time.

If your use case requires showing both the date and time, or if you want to customize the format of the “Created” column, SharePoint doesn’t allow you to directly edit columns like “Created.” But there’s a simple workaround.

You can create a calculated column and reformat the “Created” value into a new column that displays the exact date and time in the format you need.

Step-by-Step Process

Create a Calculated Column by navigating to the List Settings in your SharePoint list.

A SharePoint list page showing the list setting button at the right side of the screen

Scroll down and click on Create column.

Create Column

Configure the Calculated Column:

- Give your new column a name. In my case, I'm calling it "Date Created." - For "The type of information in this column is," choose Calculated - Under Insert Column, select the Created column from the list - In the formula text bar, enter the following formula:


=TEXT(Created,"dd/mm/yyyy hh:mm")

This formula will display the date and time in the format: 30/11/2025 14:30

testing

Finalize the Column:

- Under "The data type returned from this formula is," select Single line of text - Scroll down and click OK to save your changes - Your "Date Created" column should now display both the date and time from the original Created column

The SharePoint list showing the updated Created Column

Thank you for reading!!!

---

What did you think of this post? Let me know on Twitter or LinkedIn!

How to Show Date and Time in the Created Column of a SharePoint List

How to Show Date and Time in the Created Column of a SharePoint List

Step-by-Step Process

Rachel Irabor

☕ Support My Work