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 a

- 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 a

- 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

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