Hourly calculation

  • 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.

MC
 
Try Networkdays function in the Analysis ToolPak. This
will return the whole workdays (Monday-Friday) between two
dates. If also can taken into account holidays.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excluding week-end days/hours 1
calculate hours using start time & end time, excluding weekends 7
Calculate time differential - Mon - Fri workday basis 3
SOS-Need to calculate number of working hours per each week of mon 2
Calculating the difference between hours 1
Macro 8
Subtract day and time w/o weekends or holidays 2
Setting WEEKDAY function to Exclude Friday in Calculation 4

Back
Top