CONVERT DATA TYPE TEXT TO TIME

[SHAKEDALROY]

HI

I have a text column in an existing table. I want to remove the seconds so that it will relate to a Time table column that is in hh:mm format (with am/pm) . I know this is likely easy, but I cannot figure out the m code in order to do this. Help will be greatly appreciated.

T

[Payeras_BI · Accepted solution]

Hi @SHAKEDALROY ,

On your Violation time column:

1. Replace values --> A by AM and P by PM

2. Split the column in 3 by Number of Characters (2) with the option "Repeatedly"

3. Combine the two first columns with a ":" as separator

4. Combine the resulting column with the one left containing AM/PM with a space as separator

5. In your Ribbon > Transform > Date & Time Column > Hour > Analize

Regards


 

[SHAKEDALROY]

Thank you @Payeras_BI  appreciate the quick response🌻