How to SUM up multiple columns (TimeFieldType)

Oskido

Hi,

I am new in Altetyx.

How to SUM up multiple field in TimeFieldType.

I have attached the sample data.

Please help.

Book1.xlsx

Datasets

Tips and Tricks

Help

Accepted answers

atcodedog05

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:

Hope this helps : )

Total Time.yxmd

All comments

Sebastiaandb

@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 ;-))!

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

time add.yxmd

atcodedog05

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:

Hope this helps : )

Total Time.yxmd

Oskido

Thank you so much. It worked.

Oskido

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703