Update a column's value when another column's valu...

[Charles_DeRosa1]

I’ve got a start date in one column and I’d like to add hours from another column to have it output a date and hour for me. For instance, I start a job June 26 12:00 and I want to add 40 hours to that date. I’d like it to output “June 27 4:00” for me.

I tried the following:
DATEADD({Ramp Start Time},{Ramp Length Hours})

“Ramp start time” is a date field and “ramp length hours” is a duration field.
Currently I’ve got "ramp start time as “6/27/2020 10:00” and “ramp length hours” at 40 and it’s giving me “6/27/2020 10:02”

What am I missing?

[ScottWorld]

You need to add ‘hours’ into your DATEADD formula like this:

DATEADD({Ramp Start Time},{Ramp Length Hours},'hours')

[Charles_DeRosa1]

Thank you for this. For some reason, it’s giving me a crazy way in the future date with that formula?

So:
"ramp start time is “6/27/2020 10:00” and “ramp length hours” at 40
the result now is “11/30/2036 5:00pm”

[ScottWorld]

Oh, sorry — your “Ramp Length Hours” field needs to be a number field, not a duration field.

[Charles_DeRosa1]

That was it. Thanks so much for the help!

[ScottWorld]

You’re welcome! Glad I could help! :slightly_smiling_face: If you don’t mind, could you please mark one of my comments above as the solution to your question? This will help other people who have a similar question in the future. :slightly_smiling_face: