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) ...
Forum Discussion
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
------------------------------
ToDays([Start Date]-[End Date]) * 8
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
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
------------------------------
Hours(ToDays([Start Date]-[End Date]) * 8)​
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
