How to add or subtract minutes from a time?

ddiesel

How to I add or subtract minutes from a time field?

In this case, I need to add 30 minutes to each of my "Start Times" to get the "End Times".

DateTimeAdd([Start Time],+30,"minutes") gives conversion error: DATETIMEADD: "04:00:00" is not a valid DateTime.

I can think of a couple workarounds but is there an easy way to do this?

Sample workflow:

Time Add Sample.yxmd

Date Time

Accepted answers

MarqueeCrew

Deborah,

Please try this formula:

DateTimeAdd("2017-01-01 " +[Start Time],30,"minutes")

your time needs a date too.

Cheers,

Mark

All comments

MarqueeCrew

datetimeadd([my date],30,"minutes")

adm510

I changed EndTime from String to Time in the select tool, and the workflow ran just fine.

ddiesel

@MarqueeCrew and @adm510 ... Thanks for the fast response!

I made those two changes but I'm still not getting it.

Time Add Sample.yxmd

adm510

Hmm, the workflow you attached ran just fine for me. What if you remove the EndTime column and create it from the Formula tool instead? (see attached)

Time Add Sample (1).yxmd

ddiesel

How strange... I am still getting the same error, even with the sample workflow you sent back.

adm510

Bizarre, I'm using v11.0 so there could potentially be some differences there. From your screenshot, it doesn't seem like the addition is the problem, Alteryx is having a problem reading your start time as a time and this is why the datetimeadd fails. You may need to add the select tool back and explicitly cast start time as time... but it's still strange that it works without issue for me.

amitsrivastava

challenge_68_solution.yxmd

MohithRai

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703