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 pseudocodeIf 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 nullElse 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
Discussion posts and replies are publicly visible