Response times calculated in business hours
Is NETWORKDAYS a 2007 feature? it does not seem to be a function in 2003
"Stefi" wrote:
=B2-A2-NETWORKDAYS(A2,B2)-16*1/24
Not fully tested, but gives the correct result in your example.
Regards,
Stefi
€˛Nippy€¯ ezt Ć*rta:
Hello, i wish to calculate response times in business hours.
I have two columns of data; A represents the "call log" date and time; B
represents the "responded by" date and time.
I wish to calculate the time difference between A & B, but only in office
hours.
As an example; Office hours 9am to 5 pm Mon-Fri (no sat or Sun)
A call received at 4pm on friday that was dealt with by 10am on monday would
have a Response time of 2 hours.
Is there a neat way of doing this?
|