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 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 modify system 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")        

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.

This is the Date Created column in my SharePoint list.

Thank you for reading!