calculate SLA or TAT by excluding non-business hours

[DWB82]

Hi All

I am hoping that someone can help. I have been reading the post (Calculate only working hours between two dates excluding weekends) as it was on the right lines for what I needed but I couldn't find the specifics to help me.

I have a similar problem with the exception that I work in a 7 day operation. The hours are below:

Mon - Fri 08:00-19:00
Sat & Sun 09:00-17:30

I have been using this formula =(NETWORKDAYS.INTL(AN5,AO5,11)-1)*("19:00"-"08:00")+MEDIAN(MOD(AO5,1),"19:00","08:00")-MEDIAN(MOD(AN5,1),"19:00","08:00") but I know that it does not work when it comes to a specific day. In this case Sunday only. I am currently using office 365.

I have seen people reference this problem and be told that a more complex formula is required however, I have not got a clue where to start with this. If anyone could help with this it would be amazing!!

Hoping for help soon.

Thanks

DWB

 

[Sulprobil]

Hello,

I suggest to have a look at this thread:

Shifts and bonuses

Hi, I have a problem I have been trying to find a solution to for a while now. We have people that work shifts. Bonuses can be received for each shift depending on time and day. ---**disclaimer** this is not the actual bonus system, since we don't even use dollars in my country but it's just...

www.mrexcel.com

Regards,
Bernd