Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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