Adding 2 Times

Maltaleb001

Hi all,

I have this data and I want to add the (duration in Mins) to the time on the first column.

I tried many ways but couldn't do it. One of them is using the following function but it's not working:

Any advice on what's the best way, hopefully easy one?

Preparation

Accepted answers

afv2688

Hello @Maltaleb001 ,

Thats an interesting question. Would like to know if there is a better way than this one:

DateTimeAdd([Field1],DateTimeSeconds([Field2])+60*DateTimeMinutes([Field2])+DateTimeHour([Field2])*3600, 'seconds')

Here I am transforming the time into seconds

Hope it helps

Regards

All comments

afv2688

Hello @Maltaleb001 ,

Thats an interesting question. Would like to know if there is a better way than this one:

DateTimeAdd([Field1],DateTimeSeconds([Field2])+60*DateTimeMinutes([Field2])+DateTimeHour([Field2])*3600, 'seconds')

Here I am transforming the time into seconds

Hope it helps

Regards

Christina_H

You need to convert the time to a number field with the total number of minutes or seconds to add on in order to use DateTimeAdd. See a couple of solutions on this thread:

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

Jonathan-Sherman

Hi @Maltaleb001,

I decided to use three separate formulas to add on the hours, minutes and seconds

DateTimeAdd([DateTime],DateTimeHour(ToDateTime('1900-01-01 '  + ToString([Duration in Mins]))),'hour')

DateTimeAdd([DateTime],DateTimeMinutes(ToDateTime('1900-01-01 '  + ToString([Duration in Mins]))),'minute')

DateTimeAdd([DateTime],DateTimeSeconds(ToDateTime('1900-01-01 '  + ToString([Duration in Mins]))),'seconds')

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan

20211118 - AddingTimesyxmd.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703