Date Time to show Time

[Michaela_walsh]

Hi, I am looking for a formula that I can use that keeps the date and time in the column but only show time- similar to excel time feature. If it is possible in Alteryx, any suggestions on the formula I would write? 

Thank you!

[Deano478]

@Michaela_walsh What does the date time column look like currently?

[Andrew-Merrill-CoG]

Excel has two layers to it, the backend structure of your data, and a formatting layer on top of that. In Alteryx, you are working on the backend data. If you need a time field, you can add that as a new field and set it to the "Time" data type, while leaving a separate column with just the date or the combo date time if you need the date for some other calculation. I wouldn't create that column either until the very end of your workflow, when you are formatting your output, since every calculation you'd do can be done on the DateTime combination.

[Michaela_walsh]

@Deano478 the date time column is 01/25/2025 19:15 so ideally would like to show 19:15. There are other columns that need the date kept in the column for their formulas. 

[Michaela_walsh]

I will try adding an date column and making a time column, but it might mess up the output data. I am trying to add data to a template that is used for barcodes. Report 1 feeds into the template file. I already tried to format the excel template to see if the data would change once the specific time format was used, but that did not work.