Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
2 years ago

Duration Formula

[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 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Qrew #1 Challenger
      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
      ------------------------------