Skip to main content
Question

Duration between two dates excluding weekends by hours/mins instead of days

  • February 18, 2021
  • 0 replies
  • 284 views
I am trying to figure out the duration between two date/time fields and I want to exclude the weekends but I don't needs days, I need hours and mins. Everything that I have found so far says to use they numeric formula and weekdaysub. But with this, I only get days. Is there a way to either use the duration formula or use the numeric formula with the weekdaysub and format it to hours/mins?
Below is a screenshot of the formula I have now, it is including the weekends:



------------------------------
Nicole Varner
------------------------------
This topic has been closed for replies.

To me, the easiest thing would be to break it down into smaller bits:
 
  1. Set the Units on your Duration field properties from 'Smart Units' to 'HH:MM'
  2. Use WeekdaySub to get the # of Weekdays between the two dates
  3. Calculate the number of minutes between the starting value and midnight of that day, if the Starting value is a weekday
  4. Calculate the number of minutes between 00:01 and the ending value, if the Ending value is a weekday
  5. Add 2, 3, and 4 together 
​​

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Terms & ConditionsAccessibility statement