Discussions

Expand all | Collapse all

Adding duration to date / time field

  • 1.  Adding duration to date / time field

    Posted 11 days ago
    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
    ------------------------------


  • 2.  RE: Adding duration to date / time field

    Posted 11 days ago
    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
    ------------------------------



  • 3.  RE: Adding duration to date / time field

    Posted 11 days ago
    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
    ------------------------------



  • 4.  RE: Adding duration to date / time field

    Posted 11 days ago
    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
    ------------------------------



  • 5.  RE: Adding duration to date / time field

    Posted 11 days ago
    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
    ------------------------------