1 Reply Latest reply on May 26, 2015 12:59 PM by Rody Zakovich

    Trying to subtract weekend hours between two dates

    Bob Steven

      Customers send us transactions at all times and all days of the week. We stamp a start date on the transaction when it is created. We stamp an end date when we have completed the transaction.The difference between these two fields is the time it takes to process a transaction. We measure this in hours and do not want to count weekend hours as no one is working on weekends. Any ideas on how I subtract weekend hours from a datediff between two dates?