Adding duration to date / time field

Question

This seems like it should be simple, but I can't get the formula to work.

I have a date / time field. I have a duration field that is numeric. I have a formula date / time field.

I want to enter the start date / time, then the duration in hours, and add that together in the formula date / time field. I keep getting syntax errors. Any help out there?

------------------------------
Thanks,
Chris Newsome
------------------------------

brandondrake · Answer

Hello Chris,&nbsp;Rather than starting from scratch, what is the formula you currently have and what is the syntax error that you are getting?------------------------------Brandon Drake JHI GroupMonroeville OH------------------------------

markshnier__you · Answer

try this[my date / time field] + Hours([my hours field])------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

chrisnewsome · Answer

Dang it Mark, I knew I was making it too difficult. It was the Hours phrasing before the duration that I was missing.

Thanks as always!

------------------------------
Thanks,
Chris Newsome
------------------------------

markshnier__you · Answer

right, when you have a date time field you need to be adding a duration to it and not a number as the system does not know if that would be seconds, minutes, hours, days or weeks to add.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

dirkruana · Answer

Hi Mark:I am having a similar problem:[Date Created]+Days([Response Time Record - Response Duration])[Date Created] is Date/Time field[Response Time Record - Response Duration] is a duration fieldI am still receiving this error message:
Any ideas what I am doing wrong?&nbsp; I've tried everything I can think of.Thank you,Dirk------------------------------Dirk Ruana------------------------------

Forum Discussion

Adding duration to date / time field

Related Content

Snapshot Fields

How to stop a user from adding into a field

Create a formula duration over 5 years

Find and Replace Field Values

Consolidate Field Types