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

Question

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 CreatedDate Time ReportedTime to reportDate Time OutOn time?3/17/2025 3:423/17/2025 3:4200:00:00Yes3/17/2025 3:343/17/2025 3:3400:00:00Yes3/17/2025 21:303/17/2025 21:3870:07:00Yes3/17/2025 20:203/17/2025 21:3877 No3/17/2025 18:273/17/2025 20:441360:13:00Yes3/17/2025 18:273/17/2025 20:441360:13:00Yes3/17/2025 19:563/17/2025 20:12160:16:00No3/17/2025 19:103/17/2025 19:45350:35:00No3/17/2025 19:103/17/2025 19:45340:34:00No

Data fields:Date time created: date and time product was createdDate time reported: date and time product was reportedTime 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"

Timing Workflow.yxmd

Qiu · Answer

@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.

Timing Workflow-r1.yxzp

binu_acs · Answer

@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

Timing Workflow.yxmd