cancel
Showing results for 
Search instead for 
Did you mean: 

Need Urgent Help With webi Date formulaes

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

mhmohammed
Active Contributor
0 Kudos

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:

  1. To find out if its business hours by checking the day name and time between 6AM to 6PM
  2. To find out if its after business hours by checking for day name and time not between 6AM to 6PM.

This blog will help you with the different functions.

Thanks,

Mahboob Mohammed