Calculate Business Elapsed time with 11hr Days instead of 24

[Melissa Berry]

Is it possible to adjust the 'Business Elapsed Time' to calcualte as 11 hours = 1 Business Day?

Our business hours are 7a-6p M-F excluding holidays. So business days are 11 hours long based on the schedule applied to the SLA.  

When you pull the business elapsed time into the report its calculating 24 business hours as 1 business day instead of 2 days 2 hours (bc business days are 11 hours)

You can see this based on the below screenshot.  ‘13hours’ should have actually added 1 business day and 2 hours once it hit 11 hours.

This incident was opened on 11/6/20. This screen shot was taken on 11/30/20 so all calculations are based on the 11/30 date.

The calculation should be a slightly over double what the report is showing.

5 days = 120 hours

 + 13 hours

 + 42 min (.7 of an hour)

= 133.7 business hours/11 (1 business day) = 12.15 Business days

Any insight as to how to calculate this for reporting woudl be much appreciated.

[Angie Koester]

I am wanting to do the same thing for our company.   We have a 9 hour day working day 8am - 5pm.  I would like to see the same calculations when the hours hits 9 hours, it then changes it to 1 day, because that is considered to be a business day.  

[SK51]

Yes - exactly. 

If a day is 8 hours based on our schedule, then business elapsed time should show 1 day once it hits 8 hours, instead of 24 hours then show 1 day. This is very misleading

[lior3]

i have the same thing here

did you get any idea how to do it?

lior

[Melissa Berry]

@ lior not yet. 😞 this seems to be something SN should provide OOTB. It raises a lot of questions from the business. 

[amarks]

Hi @Melissa Berry , did you ever get a solution here?