martinjward
Registered User.
- Local time
- Today, 15:57
- Joined
- Sep 28, 2007
- Messages
- 22
I am new to VBA and I require a re-usable function that calculates the diffence between two dates in days, hours & minuites - but only for working hours, excluding bank holidays & weekends. Complicated I know, but the requirement is to work out how long a process has taken in 'business time'.
I need this to be reusable as there is potential to need this is multiple applications long term. I have a 'common' database that holds staff, site and similar information - so the addition of a list of bank holidays in the common DB and the use a link table to the application is not a problem, the same with a record in the common DB detailing working hours.
Unfortunatly the requirment is due before I get on a course and this the only bit I am really stuck on. I can not find any help on excluding bank holidays on several web sites / forums, so an example would be very greatly appreciated & make me the hero of the second.
I need this to be reusable as there is potential to need this is multiple applications long term. I have a 'common' database that holds staff, site and similar information - so the addition of a list of bank holidays in the common DB and the use a link table to the application is not a problem, the same with a record in the common DB detailing working hours.
Unfortunatly the requirment is due before I get on a course and this the only bit I am really stuck on. I can not find any help on excluding bank holidays on several web sites / forums, so an example would be very greatly appreciated & make me the hero of the second.