Only show hours & AM/PM

[Anonymous]

Hi,

How can I remove the minutes here in the Hour column? Instead of 12:00 AM, I would want 12 AM. Thanks!

[Garrysfarrell · Accepted solution]

Hi,

If you go to the model view and select the table and the column then open the proerties pane. Then change the Date time format to custom. 

You may have this h:nn AM/PM

change it to this h AM/PM

Model view

[ryan_mayu · Accepted solution]

@Anonymous 

maybe you can go to data model and change the format to custom format and change to hh AM/PM

[Garrysfarrell · Accepted solution]

Hi,

If you go to the model view and select the table and the column then open the proerties pane. Then change the Date time format to custom. 

You may have this h:nn AM/PM

change it to this h AM/PM

Model view