I am trying to have a column displayed in the...

[Wes_Bunch]

I am trying to have a column displayed in the app that usually consists of a TIME value as HH:MM.

But, sometimes this particular column may have text entered such as “ASAP” or some other short string of text.

My question is, how can I make the app show the column as time when it is indeed a time, and text when it is not time rather than the “Invalid date” error?