How to add two time fields (24 hour format) in Alteryx ? Please help

[AbhirupMukherjee09]

Hi everyone, I am looking for an easier solution on how I can add two time fields in Alteryx, For Example  -

Time1                 Time2

09:00:00            00:10:00

10:15:00            00:45:00

12:40:00            00:30:00

So I want to add these two column and get my final column as 

Time3

09:10:00

11:00:00

13:10:00

How can I get this result ? Help please             

[binuacs]

@AbhirupMukherjee09 the below post might be helpful for your use case 

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

[DataNath · Accepted solution]

Hey @AbhirupMukherjee09, here's one way you could go about achieving this where you parse out the hours/minutes/seconds of Time2 and individually add them to Time1. I've added an extra row to show all 3 working at once and correctly ticking over midnight:

The only 'standout' thing to mention is creating a *dummy* DateTime to be able to use the DateTimeAdd(), hence the '1900-01-01 '+

[AbhirupMukherjee09]

Thanks alot @DataNath. This is exactly what I was looking for.