Date diff excluding holidays and weekends
Hi Friends,
I need help on 2 accounts:-
1) If a date & time are outside business hours then need to convert to the next business hour.
eg - if date is 9 feb, 5 AM then it should be converted to 9 feb 9AM and if 9 is a holiday then it should be converted to 10 feb 9AM.
Same is the case if it is 9 feb 6:30 PM then it should be converted to 10 feb 9 AM
2) I need to find out number of working hours between 2 dates. This should exclude weekends and holidays.
I have tried everything in ASP to incorporate the above 2 requirments, but no go.
So pls help..
Alton
|