Skip to main content
Question

Adding duration to date / time field

  • May 19, 2020
  • 0 replies
  • 308 views

Forum|alt.badge.img+10
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
------------------------------

  • Quickbase Alumni
  • May 19, 2020
Hello Chris, 

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 Group
Monroeville OH
------------------------------

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • May 19, 2020
try this

[my date / time field] + Hours([my hours field])

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