Alteryx Designer Desktop Discussions

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

How to SUM up multiple columns (Time Field Type)

Oskido
6 - Meteoroid

Hi.

 

I have been looking around but not winning.

I am new in Alteryx.

I am trying to Add (SUM) multiple columns (Time Field Type) creating new column with SUM of the columns.

Example of columns:

Please see the attached file 

1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @Oskido 

 

My take on this. Managed with a single formula

 

Formula:

DateTimeAdd("1900-01-01",
DateTimeDiff([QueueTimeDuration],"00:00:00","seconds")+
DateTimeDiff([AuthenticationDuration],"00:00:00","seconds")+
DateTimeDiff([CustomerUpdateDetailsDuration],"00:00:00","seconds")
,"seconds")

 

Workflow:

atcodedog05_1-1629978995703.png

 

Hope this helps : )

Labels