 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / February 2007Response times calculated in business hours
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? =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. > [quoted text clipped - 9 lines] > > Is there a neat way of doing this? Is NETWORKDAYS a 2007 feature? it does not seem to be a function in 2003 > =B2-A2-NETWORKDAYS(A2,B2)-16*1/24 > [quoted text clipped - 18 lines] > > > > Is there a neat way of doing this? see: http://groups.google.com/group/microsoft.public.excel.misc/browse_thread/thread/ 1981c3361e2c9e9e/bd7909095823b506?lnk=st&q=%22business+hours%22+group%3A*excel&r num=5#  SignatureGary's Student gsnu200706 > Hello, i wish to calculate response times in business hours. > [quoted text clipped - 9 lines] > > Is there a neat way of doing this? Hi, in my opinion the response time is the time it took to respond to a call, from the date of logging it. The only way to do this is to do the following checks and calculate the time difference appropriately. 1. Whether reponse date is a week day i.e. on a Friday 2. Whether reponse time is at the end of a week day i.e. on a Friday > Hello, i wish to calculate response times in business hours. > [quoted text clipped - 9 lines] > > Is there a neat way of doing this? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.