Hi Team
I have activated the analysis tool pack addin and using the formula stated below.
But unfortunately its not showing the expected result.Please Login or Register to view this content.
Note:
A4 - Start Date
B4 - End Date
RDATA$AC$2:$AC$500 - contains the holiday and saturday sunday date to be excluded while calculating the difference between start and end date with time.
For example if start time is 03/06/2014 10:13 and End Time is 10/06/2014 07:26, then the result should be 4 but I'm getting 6 as the result.
Any help will be really helpful.
Best
Rem0
Bookmarks