Email Response Time

Hi All,

I have looked through pages trying to find something that may answer my question, and it appears there are other related solutions, I can't find one that includes the formatting I require to find averages of response times and considers emails to be to the nearest working day.

That isn't my question though. I'm trying to find response time (taking into consideration working hours of 6am to 6pm). If a call comes at 9pm I want to track the response time from 6am the next working day.

Please see attached. Hope it answers any questions you may have

Thanks!

Email Response Time.xlsx

Hey Dafodil11,

Thanks for the formula! It works mostly (I just changed the time from 8:00 t0 6:00 as this is the actual work hours.

However, in H8 the formula produces the wrong result. It should appear as two days response time. But instead I'm seeing it as one?

Is there a particular cell formatting you had in mind when making the formula that may be affecting the way it appears for me?

I'm using d:hh:mm

I've reattached - Thanks for all your kind efforts!

Simon

Email Response Time.xlsx

Hi there,

sorry this response is coming late, Excel Forum keeps logging me out and not registering responses (not sure if this will work either).

I don't quite understand sorry, H8 (response email) contains 17/12/2014 which is a Wednesday, so there shouldn't be any weekend disruptions as the email was received on 15/12/2014 (Monday).

The formula produces a result that is one day out.

Thanks!!

Simon