Trying to hours from one column to a date in another column

Topic Labels: Formulas
1203 5
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

5 Replies 5

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

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

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

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

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

That was it. Thanks so much for the help!

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: