Forum Stats

  • 3,770,503 Users
  • 2,253,127 Discussions
  • 7,875,489 Comments

Discussions

calculating business hours

User_JZKI6
User_JZKI6 Member Posts: 38 Green Ribbon

Hi Team,

We have to calculate the business hours between 2 dates (start date, completion date) our business hours are 9 AM to 6 PM.

For example we got ticket on Monday 9 AM and closed on Tuesday 11 AM then it has to show business hours to resolve this ticket is 11 Hrs instead of 26 Hrs.

Here we have to exclude weekends (Saturday, Sunday) and holidays can someone help in this scenario    


Regards,

Tagged:

Answers