Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 17th 04, 06:29 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2004
Posts: 2
Default Hourly calculation

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.

MC




  #2   Report Post  
Old August 17th 04, 07:05 PM posted to microsoft.public.excel.programming
djh djh is offline
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2003
Posts: 8
Default Hourly calculation

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.




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

MC



.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hourly average help bob New Users to Excel 10 July 5th 09 12:05 AM
How to convert half hourly data into hourly kippers Excel Discussion (Misc queries) 5 February 1st 07 11:27 AM
Calculation of hourly rate times hours times 1.5 Newbusinessbod Excel Worksheet Functions 1 December 6th 05 05:44 PM
Hourly rates Dreamstar_1961 Excel Worksheet Functions 3 November 2nd 05 12:33 PM
How can I do an hourly salary calculation in Excel AndyM Excel Discussion (Misc queries) 2 September 15th 05 05:29 AM


All times are GMT +1. The time now is 01:05 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017