Skip to main content

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?

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



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

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?



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”

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”


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

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!

That was it. Thanks so much for the help!


You’re welcome! Glad I could help! 🙂 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. 🙂

Reply


Terms & Conditions