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

Workflow

Tips and Tricks

Date Time

Time Series

Accepted answers

DataNath

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 '+

Adding two time fields.yxmd

All comments

binu_acs

@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

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

Adding two time fields.yxmd

AbhirupMukherjee09

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703