Skip to main content
Question

Duration Formula

  • August 4, 2022
  • 0 replies
  • 28 views
Forum|alt.badge.img+11
[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
------------------------------

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement