10 Replies Latest reply on Feb 11, 2019 8:59 PM by Kielty Walsh

    Date Difference in Minutes, Excluding weekends

    Kielty Walsh

      I have seen this general issue discussed in a couple of forums, however my case scenario is a bit different - Looking to see if anyone has run into this.

       

      I am looking to get the difference in minutes between two dates. I do not want to count minutes after hours or on the weekends. However some of my start dates begin outside of work hours, and on the weekends. For example we will receive an email at 7:55 am on a Saturday. And we respond at 10:30am on a Monday. I am looking to only have it count the minutes from opening at 8am till we responded at 1030am?

       

      In addition I will want to exclude public holidays, however I would assume I can use similar logic from above, and other threads to solve for that.

       

      Thanks!