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