on 09-28-2016 8:55 PM
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
Hi Archana,
This can help you get started to calculate the duration between two date timestamps.
http://scn.sap.com/message/16300382#16300382
Apart from that you'll have to create a bunch of flags:
This blog will help you with the different functions.
Thanks,
Mahboob Mohammed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.