Calculate timelapse without weekend hours
Posted on 2003-03-13
For a current assignment I need to calculate the amount of hours between two points in time (not too difficult), but keeping in mind that
- these two points can lie as much as a couple of months apart
- the hours between saturdays 06:00 and mondays 06:00 do not count
- these "weekend begin and end times" could be changed
- this is a VBA (Access) environment
I rated this question 100 points: should not be too difficult (eventhough I have no idea), but is rather urgent...
Any tips would be welcomed!