Negating Work days and Work Hours from set response periods

[nicoleblackham]

Hello,

I have the challenge of calcuting response times within 1 working day for cases filed by my clients. My current function does not account for workdays and holidays. So if a case is filed on a Friday evening and I respond on Monday morning, I have missed my allowed response time window of 1 working day.

The Data that I have to work with:

Case Create Date and Time
Response Date and Time

What I have:

=IF(Sum(Create Date-Response Date)<=1,"","Update Response Time")

What I need:

=IF(Sum(Create Date-Response Date)<=1,'","Update Response Time"), Unless the difference being >1 is due to a weekend or holiday.

Thanks for the help

 

[Michaels]

Hello !

Can you explain further? Your data did not come through in a view that shows what you want. Perhaps you can use the HTML maker or post a screen shot. If not, please provide a more detailed senario so we can follow it.

 

[barry houdini]

Will the times (case filed, response time) both be within working hours?

If so you could use a fomula like

=IF(NETWORKDAYS(A2,C2)-1+D2-B2<=1......

where A2 has create date B2 create time, C2 response date and D2 response time