Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Time elapsed in hours between two dates excluding weekends and holidays
Is there any way for me to revise the Workdays function to calculate how many holidays there are? I can then take the result, muliply by 24 and subtract the number from the total hours I get from teh Weekdays function. I am not an expert in VBA and normally copy the code, not produce my own...- nadery
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Time elapsed in hours between two dates excluding weekends and holidays
I am trying to calculate the number of hours between two dates and exclude weekends and holidays. I have two functions in my Access module: Weekdays and Workdays. The Weekdays function seems to work fine. However, I am having difficulty with the Workdays function, which excludes holidays (listed...- nadery
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
