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

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

2. Scroll down and click on Create column.

3. Give your new column a name. In my case, I’m calling it “Date Created.”
For the option “The type of information in this column is,” choose Calculated.
Next, under Insert Column, select the Created column from the list.
Then, 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

Under “The data type returned from this formula is,” select Single line of text.
Once you’re done, scroll down and click OK to save your changes.
Now, your Date Created column should display both the date and time from the original Created column.

Thank you for reading!!!

---

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