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

7 Replies

Related Content

Duration Fields with Pipelines

Pop up Message when child is added and field on parent record changes

Formula Checkbox and Duration

time duration

Timeline or Duration shown visually as a field?

Recent Discussions

Many to Many too Many...

Selecting which fields to display from Formula URL searches

Bulk create child records from selection list

(Pipelines) Get Users in Role / Process XML from HTTP API

Help Needed with Quickbase Pipeline to Accumulate Values Instead of Overwriting