Skip to Content
0
Former Member
Sep 28, 2016 at 07:55 PM

Need Urgent Help With webi Date formulaes

16 Views

I have two dates Open Date and Assignment Date both are Dates. My requirement is

Ticket NumSample Open Date Assignment Date

12345 9/24/2016 9:25 AM 9/24/2016 10:15 AM

13456 9/25/2016 10:25 AM 9/24/2016 6:15 PM

1) Calculate Difference between Open Date and Assignment Date in Minutes -- Response Time

2) Number of Tickets where Response Time <15 minutes during Normal Business Hours (M-F 6 AM TO 6 PM)

3) Number of Tickets where Response Time <30 After Business Hours

4) Number of Tickets where Response Time <180 Min During Business Hours

5) Nmber of Tickets where Response Time is : Next Business Day Before Business Hours