I need a column in a custom list that shows time only - such as 6:00 or 23:45 - the only thing I see to possibly use is text only. Is there another better way?? thanks

3 Answers 3


you need two columns for this. First is time and date column, and in second column would be a calculated column. apply =TEXT([first column name],"hh:mm AM/PM") , it will only display the time

  • could you help me create a rule in a column to show an hour. The point is that I need in a column with an hour, which is visible only when in another column I have specified text "ok".
    – user84240
    May 10, 2019 at 6:59
  • why not, pls elaborate your requirement
    – cjs
    Jun 26, 2019 at 16:08

If "Created" or "Modified" field is okay to use as a source, create a new calculated field with formula

=TEXT(Created,"hh:mm AM/PM")

The data type returned from the formula can be one of the below

  1. Single line of text
  2. Date and Time (Date & Time format)

This should give time only as in the screenshot below

enter image description here


You can create a Calculated field of type - Date and Time with format as "Date & Time" and use the below formula (taken from Link):

=IF(HOUR(Created)<12,HOUR(Created)&":"&Minute(Created)&" AM", (HOUR(Created)-12)&":"&MINUTE(Created)&" PM")

The only problem I notice is that if the time is 2:00 PM, the value in calculated formula will be displayed as 2:0 PM instead of 2:00 PM. So, you may need to format a little bit.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.