Thank this author by sharing:
By Megan Beebe, 2008/07/18
Business timeliness calculations usually require only working hours and working days to count. The above formula is based on a numeric pattern displayed by a review of all possible combinations of start day of the week, end day of the week and days different.
I'm also posting a function that returns the business days, hours, minutes or seconds elapsed.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
