Others

How to Display Only the Time in a Microsoft Lists Date Column

Maira Mehtab Sep 22, 2026 870 views

Question details

The user wants to format a Date and Time column in Microsoft Lists or SharePoint to show only the time, completely hiding the date.

Product: Microsoft Lists / SharePoint
Device & OS: not provided
Scenario: Managing list views where the date is irrelevant and displaying only the time component improves readability.
Observed behavior: The default Date and Time column forces the display of both the date and the time, with no built-in toggle setting to show the time alone.

Before you start

Ensure you have the appropriate list editing permissions in Microsoft Lists or SharePoint to create new columns and modify the active list view.

Solution 1Recommended

Use a Calculated Column Formula to Extract Time

Since there is no native toggle to hide the date, creating a new Calculated column is the standard workaround to display only the time.

Microsoft Lists and SharePoint do not natively allow you to remove the date from a standard Date and Time column. You can resolve this limitation by creating a separate Calculated column that reformats the original data to output only the time component.

Add a Calculated Column

Navigate to your Microsoft List or SharePoint list. Click on 'Add column' at the far right of your list headers, and select 'More...' or 'Calculated' from the dropdown options.

Enter the Extraction Formula

Name your new column (for example, 'Time Only') and paste the following formula into the formula box: =TEXT([Your Date Column Name],"hh:mm"). Make sure to replace '[Your Date Column Name]' with the exact name of your original date column.

Set the Correct Data Type

Under the formula box, ensure the 'The data type returned from this formula is' option is set to 'Single line of text', then click 'OK' or 'Save' to create the column.

Hide the Original Column

To clean up your view, click on the header of the original Date and Time column, select 'Column settings', and choose 'Hide this column'. Your list will now display only the newly formatted time column.

Formula Variations for 12-Hour Clock: If you prefer a 12-hour clock display instead of military time, you can adjust the formula format string. Use =TEXT([Your Date Column Name],"hh:mm AM/PM").

Free Microsoft Office alternative

Manage Data Easily with WPS Office Spreadsheet

If you find Microsoft 365 tools like Lists or SharePoint too complex for simple data tracking and formatting, consider switching to WPS Office. WPS Spreadsheet allows you to change date and time formats instantly with built-in cell formatting, completely avoiding the need for complex formula workarounds.

1. Open Your Data: Launch WPS Spreadsheet and open the document containing your date and time data.
2. Select Format Cells: Highlight the column or cells you want to modify, right-click, and select 'Format Cells'.
3. Choose Time Format: Navigate to the 'Number' tab, click on 'Time' in the category list, and select your preferred time-only display format.
4. Apply Changes: Click 'OK' to instantly hide the dates and display only the time across all selected cells.

Highly compatible with Microsoft Excel (.xlsx) formats for seamless data migration.Easily format date and time cells with a few clicks—no formulas required.Lightweight and fast, saving system resources compared to heavy web applications.Familiar, intuitive user interface for quick onboarding and data management.

Frequently Asked Questions

Can I change the default Date and Time column to show only time without adding a new column?

No, Microsoft Lists and SharePoint do not offer a native setting to completely hide the date within a standard Date and Time column. Using a Calculated column to extract the time is the required workaround.

Will the Calculated column update automatically if the original date changes?

Yes. Because the Calculated column directly references the original Date and Time column, any modifications made to the original record will automatically be reflected in the Calculated column.

Why does my calculated formula return a syntax error?

Syntax errors typically occur if the column name is spelled incorrectly, the square brackets are missing, or if your regional settings require a semicolon instead of a comma to separate formula arguments (e.g., =TEXT([Date];"hh:mm")).

How do I show AM or PM in my extracted time column?

You can update your calculated formula to include the AM/PM identifier. Use the formula =TEXT([Your Column Name],"hh:mm AM/PM") to successfully display the time in a 12-hour format.

Office Quick Solutions