Help with converting field from minutes to HH:MM:SS

[MMManji]

Hi Alteryx Community,

Pretty new to Alteryx and I was hoping you could help me with an issue I've been having and am unable to resolve. I currently have a field (Date Time Out) that is set up to reflect the difference in minutes but every time i try to change/modify it to HH:MM:SS, I'm unable to. 

Attached is the Alteryx workflow and below is a sample data file.

Date Time Created	Date Time Reported	Time to report	Date Time Out	On time?
3/17/2025 3:42	3/17/2025 3:42	0	0:00:00	Yes
3/17/2025 3:34	3/17/2025 3:34	0	0:00:00	Yes
3/17/2025 21:30	3/17/2025 21:38	7	0:07:00	Yes
3/17/2025 20:20	3/17/2025 21:38	77		No
3/17/2025 18:27	3/17/2025 20:44	136	0:13:00	Yes
3/17/2025 18:27	3/17/2025 20:44	136	0:13:00	Yes
3/17/2025 19:56	3/17/2025 20:12	16	0:16:00	No
3/17/2025 19:10	3/17/2025 19:45	35	0:35:00	No
3/17/2025 19:10	3/17/2025 19:45	34	0:34:00	No

Data fields:

Date time created: date and time product was created

Date time reported: date and time product was reported

Time to report: [Date time reported] - [Date time created]

Date Time Out: Time format of [Time to report]

On time: if [Date Time Out] is less than or equal to 15 min, then "yes" else "no"

[binuacs]

@MMManji I assume your date fields are in the format of mm/dd/yyyy hh:mm format in the input file, so i used the multi-field tool to change to yyyy-mm-dd hh:mm format then applied the formula, if you already have the yyyy-mm-dd hh:mm in your input file you can remove the multifield field

[Qiu]

@MMManji 
I dont get why you need the Date Time Out to be in "HH:MM:SS" if you just want to check if they are less than or equal to 15 min?

How come that we can not use the column "Time to report" in your sample?
Anyway, for the format of "HH:MM:SS", we can do something like this.