Excluding week-end days/hours

  • Thread starter Thread starter Marie-Claire Smeets
  • Start date Start date
M

Marie-Claire Smeets

Can somebody help me to get me on track for the following. To do some
'action-reaction' calculation via a VBA macro I need to exclude week-end
days/hours out of my result.

Please find below an example with the criteria that should be taken into
account.


Action date Reaction date Hours without week-end
5/aug/2004 9/aug/2004 ? hours
9/aug/2004 22/jul/2004 ? hours


Conditions to be taken into account are:

- VBA macro should exclude week-end days
- Week-end starts Friday after 5.00 o'clock PM and ends on Monday
08.00 AM






Many thanks for anybody who had already some VBA experience in this area.

B.rgds,
MC
 
-----Original Message-----
Can somebody help me to get me on track for the following. To do some
'action-reaction' calculation via a VBA macro I need to exclude week-end
days/hours out of my result.

Please find below an example with the criteria that should be taken into
account.


Action date Reaction date Hours without week-end
5/aug/2004 9/aug/2004 ? hours
9/aug/2004 22/jul/2004 ? hours


Conditions to be taken into account are:

- VBA macro should exclude week-end days
- Week-end starts Friday after 5.00 o'clock PM and ends on Monday
08.00 AM
Click to expand...
Many thanks for anybody who had already some VBA experience in this area.

B.rgds,
MC
Click to expand...
MarieC

Something like this will start you off

Dim c
Dim t As Double

For Each c In Selection
If Weekday(c) = 6 Or Weekday(c) = 6 _
Or Weekday(c) = 5 And t > 0.70833 Then
' your code
End If
Next

Regards
Peter
(e-mail address removed)
 
Back
Top