Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

How to SUM up multiple columns (TimeFieldType)

Oskido
7 - Meteor

Hi,

 

I am new in Altetyx.

How to SUM up multiple field in TimeFieldType.

 

I have attached the sample data.

 

Please help.

5 REPLIES 5
Sebastiaandb
12 - Quasar

@Oskido 

 

Here are some solutions for you. @MarqueeCrew  (i added his solution to the post) and @RodL made some nice examples (i learned something as well in the process haha ;-))! 

I added @

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Adding-Times-Together/td-p/8658 

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_0-1629979020410.png

 

Hope this helps : )

Oskido
7 - Meteor

Thank you so much. It worked.   

Oskido
7 - Meteor

Thank you for your assistance. I tried this one already and could not help.

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Oskido 

Cheers and have a nice day!

Labels
Top Solution Authors