I'm trying to determine the interval between two events in a process, only counting business hours.

I'm trying to determine the interval between two events in a process, only counting business hours. It's for a metric based on minutes, so I can't take advantage of calworkdays or calworkhours. I finally got a convoluted equation to work, but it seems to be adding time rather than removing it to resolve the business time issue. Any assistance would be appreciated.

ITO Notify Duration pseudocode


If request required approval
          If Approval Timestamp and Acceptance TS are NOT blank
                    If approval and acceptance occurred on the same day (take holidays into account)
                              Acceptance TS - Approval TS
                    Else
                              Acceptance TS - Approval TS -
                              # of working days between dates * 14 hrs -
                              # of nonworking days between dates * 24 hours
          Else null
Else
          If Submittal TS and Acceptance TS are NOT blank
                    If submittal and acceptance occurred on the same day (take holidays into account)
                              Acceptance TS - Submittal TS          
                    Else
                              Acceptance TS - Submittal TS -
                              # of wo...

OriginalPostID-77985