Conditional + date calculation
Hi,
I deal with cases on daily basis and have a business rule that if the case is received before 3pm the case has 48 hrs (2 business days) to be completed but if it is received after 3 pm the case has 72 hrs (3 business days). How can I calculate this? Ex. Cell A1 has date 3/28/2008 3:06:36 PM The due date in cell B2 should be 4/2/08 3:06:36 PM (should exclude sat,sun, and federal holidays) Thank you in advance, |
Conditional + date calculation
On Apr 10, 8:13*am, rvelez wrote:
Hi, I deal with cases on daily basis and have a business rule that if the case is received before 3pm the case has 48 hrs (2 business days) to be completed but if it is received after 3 pm the case has 72 hrs (3 business days). How can I calculate this? Ex. Cell A1 has date 3/28/2008 3:06:36 PM The due date in cell B2 should be 4/2/08 3:06:36 PM (should exclude sat,sun, and federal holidays) Thank you in advance, This would be fairly simple... until the monkey wrench of excluding federal holidays :-) Unless someone else knows a better way of doing it, I think you'd have to set up special conditions to check for those dates and then skip them if they fall within the two/three day range you're speaking of. For date calculations in Excel, my best advice is to read what Chip Pearson, Excel guru, has to say about them. He can explain it much better than I could: http://www.cpearson.com/excel/DateTimeWS.htm Hope that helps, Cory |
All times are GMT +1. The time now is 09:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com