Discussions

 View Only
  • 1.  Duration Formula

    Posted 08-04-2022 18:05
    [Start Date]-[End Date}

    Start Date is 8/15
    End Date is 8/18

    Need to return 3 days as the quantity, but this returns 2 days

    Also, I then want the 3 days to convert to 24 hours (3 work days)

    Please advise.
    thank you

    ------------------------------
    BuildPro
    ------------------------------


  • 2.  RE: Duration Formula

    Posted 08-04-2022 19:15
    I think that you mis-stated your question.  You probably mean that this is a 4 day job because it runs across the 15th, 16th, 17th and 18th.

    ToDays([Start Date]-[End Date]) * 8

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Duration Formula

    Posted 08-04-2022 19:16
    That would be the # of hours as a number.  I you wanted a duration as the result, then

    Hours(ToDays([Start Date]-[End Date]) * 8)

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------