SOLVED
How to SUM up multiple columns (TimeFieldType)
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Oskido
7 - Meteor
‎08-26-2021
04:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am new in Altetyx.
How to SUM up multiple field in TimeFieldType.
I have attached the sample data.
Please help.
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
- Help
- Tips and Tricks
5 REPLIES 5
Sebastiaandb
12 - Quasar
‎08-26-2021
04:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎08-26-2021
04:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 : )
‎08-26-2021
06:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much. It worked.
‎08-26-2021
06:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for your assistance. I tried this one already and could not help.
atcodedog05
22 - Nova
‎08-26-2021
06:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @Oskido
Cheers and have a nice day!