How to Show Date and Time in the Created Column of a SharePoint List
In short: SharePoint shows only the date in a list's Created column by default. To display the time as well, create a calculated column that reformats the Created value, for example =TEXT(Created,"dd/mm/yyyy hh:mm"), and return it as a single line of text. It takes about two minutes in List Settings.
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. By default, however, SharePoint displays only the date and leaves out the time.
If you need to show both the date and the time, or want a specific format, you cannot edit system columns such as “Created” directly. There is, however, a simple workaround.
Create a calculated column that reformats the “Created” value and displays the date and time in exactly the format you need.
How do you show both date and time in the Created column?
- Create a Calculated Column by navigating to the List Settings in your SharePoint list.
- Scroll down and click on Create column.
- Configure the Calculated Column:
=TEXT(Created,"dd/mm/yyyy hh:mm")
This formula will display the date and time in the format: 30/11/2025 14:30
- Finalize the Column:
Formatted timestamps are a small detail that makes a big difference, they are what keeps something like a payment approval audit trail readable at a glance. And SharePoint lists can do far more than store data: here is how they power automated crew assignment and job dispatch.
Thank you for reading.
---
What did you think of this post? Let me know on LinkedIn!
If you have any questions, you can get in touch.
Questions or thoughts? Leave a comment
Comments are moderated, your comment will appear after approval.