Associate
- Joined
- 15 Jun 2009
- Posts
- 2,494
I have a database which, Amongst other information, has a time started and a time finished field. From those, There is a calculated field to work out how long in hours there was between those dates.
However, it doesn't take into account weekend, So if it was started on a Friday and finished on a Friday, it would show an extra ~48 hours on that.
Is there anyway to let it calculate minus the weekends?
*May I also add 'Is there any EASY way to do this'? Most of the VB stuff I don't understand.
However, it doesn't take into account weekend, So if it was started on a Friday and finished on a Friday, it would show an extra ~48 hours on that.
Is there anyway to let it calculate minus the weekends?
*May I also add 'Is there any EASY way to do this'? Most of the VB stuff I don't understand.