Skip to Content
0
Aug 02, 2016 at 07:40 PM

Excluding hours

23 Views

My customer wants to calculate the response time from when a message comes into the queue (datetime field) until it is responded to. However, if the message enters the queue after 9 p.m., the clock should not start ticking until 7 am the next day.

What would that formula look like?

TIA. Wendy