Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.

How can I suntract 2 time columns?

Highlighted
7 - Meteor

Hi, Can you please advise on subtracting 2 time columns?

I Have 2  columns (A,B), converted from string to time by Parse in  HH:mm:ss format. I need to create new column A-B.

Can you please advise?

Highlighted
Moderator
Moderator

Hi @Nargess,

 

You can use a Formula tool with the DateTimeDiff function. Link to the Help documentation below.

 

DateTimeDiff(dt1,dt2,u)

https://help.alteryx.com/current/Reference/Functions.htm

Labels